Stack Gems
Menu

Best of · Databases

Best SQLite and embedded databases (2026)

Stack Gems reviews 6 SQLite and embedded databases: 6 free or open source. These are the top 6, each with its verdict and the Catch we would want to know before installing it.

Order: free and open source first, then hosted products with a real free tier, then paid-led; catalog order inside each group, with quiet or archived repos last. Not a score, and no tool pays for its place.

6 reviewed · 6 shown in full

  1. 1.TursoSQLite at the edge with libSQL

    Free / OSS · Freemium · 24.8k GitHub stars

    VerdictSQLite for the edge era, with surprising capabilities.

    CatchSQLite limitations still apply—no concurrent writes from different regions. The embedded replica model has a learning curve. Less battle-tested than Postgres.

  2. 2.SQLiteThe most deployed database in the world

    Free / OSS · OSS/MIT

    VerdictGood enough for more applications than you realize.

    CatchSingle writer at a time limits write concurrency. Not designed for network access. Feature set is smaller than Postgres.

  3. 3.PocketBaseSQLite backend, auth, and admin UI in one Go binary

    Free / OSS · OSS/MIT · 61.5k GitHub stars

    VerdictThe one-binary BaaS. Perfect until you need Postgres.

    CatchSQLite is the database. Concurrent writes and multi-region are not the product. There is no official hosted PocketBase Cloud. You run the binary, you own backups, you own the disk filling up.

  4. 4.LitestreamApache-2.0 SQLite WAL replication to S3 or local disk

    Free / OSS · Apache-2.0 · 14.5k GitHub stars

    VerdictApache-2.0 SQLite WAL stream. Replication tool, not a DB product.

    CatchOps/replication beside SQLite/Turso/PocketBase — not a new database. You still pick the SQLite host. Distinct from Turso (libSQL edge) and PocketBase (BaaS binary).

  5. 5.libSQLMIT open-contribution fork of SQLite (Turso engine)

    Free / OSS · OSS/MIT · 17.3k GitHub stars

    VerdictMIT SQLite fork. Free forever.

    CatchEngine, not a hosted fleet - Turso gem covers the SaaS product. Distinct from Turso hosted and sqlite-vec extension.

  6. 6.rqliteMIT distributed, fault-tolerant SQLite over Raft

    Free / OSS · OSS/MIT · 17.8k GitHub stars

    VerdictThe easiest way to make SQLite highly available — great for config and critical small data.

    CatchWrites go through the Raft leader, so write throughput is that of one node; it is for reliability, not write scale-out. You talk to it over its HTTP API rather than a standard SQLite driver, and non-deterministic SQL functions need care. Cluster sizing and quorum are now your job.

FAQ

What is the top free pick among SQLite and embedded databases?
Turso leads the Stack Gems list for SQLite and embedded databases. Verdict: SQLite for the edge era, with surprising capabilities.
How many SQLite and embedded databases does Stack Gems review?
6: 6 free or open source. Each review has a verdict and an honest Catch; no tool pays for its spot.
Which SQLite and embedded databases can I self-host for free?
SQLite, PocketBase, Litestream, libSQL and rqlite.
Which SQLite and embedded databases have the most GitHub stars?
PocketBase (61.5k), Turso (24.8k), rqlite (17.8k), per GitHub on 2026-10-19. Stars measure attention, not fit; read the Catch.
What is the catch with Turso?
SQLite limitations still apply—no concurrent writes from different regions.

Alternatives

Tags in this list

Related lists

JSON: /api/gems?subcategory=sqlite-and-embedded · MCP: best_for on /api/mcp