The SQLite Renaissance: Why Everyone Is Rediscovering the World's Most Deployed Database
March 22, 2026
SQLite is installed on more devices than any other database software in history. It ships in every iPhone, every Android phone, every Mac, every Windows PC, every browser, and most embedded systems. Yet for years, web developers treated it as a toy. That perception is changing fast.
The shift started with Litestream, a tool that streams SQLite changes to S3-compatible storage in real time, effectively giving SQLite disaster recovery. Then came LiteFS from Fly.io, which enables distributed SQLite with FUSE-based replication. Then Turso built a globally distributed SQLite service on top of libSQL. Then Cloudflare shipped D1, a serverless SQLite offering at the edge.
Why is SQLite having a moment? Most applications are read-heavy, and SQLite's read performance is exceptional — often faster than Postgres for single-node workloads because there is no network round-trip. The operational simplicity is profound: no server to manage, no connection pooling, no authentication configuration. The database is a file.
The libSQL fork deserves special attention. It adds extensions that SQLite's conservative development process would never accept: vector search, encryption at rest, and a network protocol for remote access. This is SQLite for the modern era.
For indie developers and small teams, the calculus is compelling: deploy your app and your database as a single artifact, replicate to S3 for backups, and scale vertically until you genuinely need distributed writes. Most apps never reach that point. The lesson SQLite teaches is that simplicity is a feature.