The Most Deployed Database on Earth

One trillion live databases

SQLite is everywhere — and we mean everywhere. It runs on every iPhone, every Android device, every Mac, every Windows 10/11 machine, and inside every modern web browser. It ships with every Python install. Conservative estimates put the number of active SQLite databases on Earth above one trillion.

Every iMessage you send, every Chrome bookmark you save, every Safari tab you reopen, every Firefox autofill, every Android app's local cache — all SQLite. NASA's Mars Curiosity and Perseverance rovers carry it. Airbus A350 avionics use it. Bloomberg terminals embed it. Dropbox, Skype, and iTunes have shipped on it for over a decade.

And yet many developers still dismiss SQLite as just a toy database or only for mobile apps. That perception is years out of date. Modern SQLite (3.53.0 as of 2026) is a powerful, full-featured relational engine that handles workloads most developers think require Postgres.

This quest teaches SQLite from the ground up — basic SQL through advanced features, Python integration, async patterns, full-text search, and production deployment. By the end you will know why the renaissance is real and how to use SQLite without hand-waving past its sharp edges.

Self-reference: Pippa's own data layer is SQLite + JSONL. The conversation rows the WebUI shows you live in ~/pippa-db/conversations.db — opened by the same aiosqlite driver this quest will teach you to use.

Code

Look — SQLite is already on your machine right now·bash

# macOS / Linux / Windows (with Python) — already installed
python3 -c 'import sqlite3; print(sqlite3.sqlite_version)'
# 3.43.0  (or newer)

# CLI is usually preinstalled on macOS and most Linux distros
sqlite3 --version
# 3.43.2 2023-10-10 13:08:14 ...

# Open a brand-new database — no daemon, no setup, no port
sqlite3 demo.db
# SQLite version 3.43.2 2023-10-10 13:08:14
# Enter ".help" for usage hints.
# sqlite>

Where Pippa keeps her own SQLite file·bash

ls -la ~/pippa-db/conversations.db*
# -rw-r--r-- conversations.db        # main database
# -rw-r--r-- conversations.db-wal    # WAL log (covered in track 4)
# -rw-r--r-- conversations.db-shm    # shared memory index

sqlite3 ~/pippa-db/conversations.db '.tables'
# branches conversations folders messages

Exercise

On your own machine, find three SQLite database files outside of this quest's directory. Hints: ~/Library/ on macOS, ~/.config/ on Linux, browser profile folders, Python ~/.cache/. For each, note the application that owns it, the file size, and whether you can open it read-only with the sqlite3 CLI without breaking the host app. Write up what you found in a paragraph.

The Most Deployed Database on Earth

One trillion live databases

Code

External links

Exercise

Progress

Comments 0