The database on your phone that nobody installed

You've never downloaded SQLite, yet you're almost certainly carrying dozens of copies right now. It's the most widely deployed database engine on Earth — baked into every Android and iPhone, every major web browser, macOS, Windows, and countless apps. Your text messages, browser history, and app settings very likely live inside SQLite files.

The trick is that SQLite is serverless and embedded. Traditional databases like Postgres or MySQL run as a separate program you connect to over a network. SQLite is just a small C library that your app links directly, reading and writing an ordinary single file on disk. No server to start, no ports, no configuration — the whole database is one portable file you can copy or email.

Two surprising facts define the project. First, it's public domain, not merely open source: the authors formally disclaim copyright, so anyone can use it for anything with zero strings attached. Second, it is astonishingly well-tested — the project maintains hundreds of times more test code than actual source code, with 100% branch-test coverage. That obsessive testing is why aviation and other safety-conscious systems trust it.

SQLite isn't trying to replace big client-server databases for high-traffic websites with many writers. It shines as the default store for local, single-application data — which turns out to be almost everywhere.