{"data":[{"slug":"turso","name":"Turso","tagline":"SQLite at the edge with libSQL","category":"databases","url":"https://turso.tech","github":"https://github.com/tursodatabase/turso","pricing":"freemium","hook":"Turso puts SQLite at the edge, globally replicated.","whatsGood":"SQLite simplicity with global distribution. Embedded replicas mean reads are local. Per Turso's own README, new projects should start on Turso Database (MIT, tursodatabase/turso — the in-process Rust rewrite of SQLite); the libSQL fork is its own gem. libSQL adds features SQLite lacks. The latency benefits are real for edge-deployed applications.","theCatch":"SQLite limitations still apply—no concurrent writes from different regions. The embedded replica model has a learning curve. Less battle-tested than Postgres.","verdict":"SQLite for the edge era, with surprising capabilities.","addedAt":"2026-08-19","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"SQLite & Embedded","tags":["free-tier","permissive","active"],"capabilities":[],"surfaces":["Hosted"],"ecosystem":["Multi-platform"],"licenseModel":"Freemium","githubStars":24824,"starsPerWeek":151,"access":"free","archived":false,"repo":{"createdAt":"2023-08-26","pushedAt":"2026-10-19","license":"MIT","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/turso","html":"/gems/turso","markdown":"/gems/turso.md"}},{"slug":"sqlite","name":"SQLite","tagline":"The most deployed database in the world","category":"databases","url":"https://sqlite.org","github":null,"pricing":"open-source","hook":"SQLite is good enough for more than you think.","whatsGood":"Zero configuration, zero server, zero administration. Single-file database is infinitely portable. Write-ahead logging handles concurrent reads. Used by every browser and mobile app.","theCatch":"Single writer at a time limits write concurrency. Not designed for network access. Feature set is smaller than Postgres.","verdict":"Good enough for more applications than you realize.","addedAt":"2026-08-19","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"SQLite & Embedded","tags":["self-host","permissive"],"capabilities":[],"surfaces":["Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"OSS/MIT","githubStars":null,"starsPerWeek":null,"access":"free","archived":false,"repo":null,"links":{"self":"/api/gems/sqlite","html":"/gems/sqlite","markdown":"/gems/sqlite.md"}},{"slug":"pocketbase","name":"PocketBase","tagline":"SQLite backend, auth, and admin UI in one Go binary","category":"databases","url":"https://pocketbase.io","github":"https://github.com/pocketbase/pocketbase","pricing":"open-source","hook":"PocketBase is Firebase if Firebase were one file you scp to a $5 VPS.","whatsGood":"MIT. Realtime, auth, file storage, and an admin UI from a single binary. Embed it as a Go library or run pocketbase serve. JS client talks REST. This is the backend you hand to a friend without a cloud bill.","theCatch":"SQLite 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.","verdict":"The one-binary BaaS. Perfect until you need Postgres.","addedAt":"2026-09-03","featured":false,"domain":"Databases","subSpecialty":"SQLite","subcategory":"SQLite & Embedded","tags":["self-host","permissive","auth","active"],"capabilities":["baas","sqlite","auth"],"surfaces":["Self-host"],"ecosystem":["Go"],"licenseModel":"OSS/MIT","githubStars":61488,"starsPerWeek":275,"access":"free","archived":false,"repo":{"createdAt":"2022-07-05","pushedAt":"2026-10-14","license":"MIT","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/pocketbase","html":"/gems/pocketbase","markdown":"/gems/pocketbase.md"}},{"slug":"litestream","name":"Litestream","tagline":"Apache-2.0 SQLite WAL replication to S3 or local disk","category":"databases","url":"https://litestream.io","github":"https://github.com/benbjohnson/litestream","pricing":"open-source","hook":"Litestream is the WAL stream that makes a single SQLite file survivable off-box.","whatsGood":"Apache-2.0. Continuous SQLite WAL replication to S3-compatible object storage or local paths. Restore by pointing at a replica. Ops binary, not a new query engine.","theCatch":"Ops/replication beside SQLite/Turso/PocketBase — not a new database. You still pick the SQLite host. Distinct from Turso (libSQL edge) and PocketBase (BaaS binary).","verdict":"Apache-2.0 SQLite WAL stream. Replication tool, not a DB product.","addedAt":"2026-09-04","featured":false,"domain":"Databases","subSpecialty":"SQLite","subcategory":"SQLite & Embedded","tags":["self-host","permissive","active"],"capabilities":["sqlite","replication","wal"],"surfaces":["Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"Apache-2.0","githubStars":14503,"starsPerWeek":46,"access":"free","archived":false,"repo":{"createdAt":"2020-10-06","pushedAt":"2026-10-16","license":"Apache-2.0","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/litestream","html":"/gems/litestream","markdown":"/gems/litestream.md"}},{"slug":"libsql","name":"libSQL","tagline":"MIT open-contribution fork of SQLite (Turso engine)","category":"databases","url":"https://turso.tech/libsql","github":"https://github.com/tursodatabase/libsql","pricing":"open-source","hook":"libSQL is the MIT SQLite fork with open contributions under Turso.","whatsGood":"MIT. SQLite-compatible with replication hooks and Wasm builds.","theCatch":"Engine, not a hosted fleet - Turso gem covers the SaaS product. Distinct from Turso hosted and sqlite-vec extension.","verdict":"MIT SQLite fork. Free forever.","addedAt":"2026-09-06","featured":false,"domain":"Databases","subSpecialty":"SQLite","subcategory":"SQLite & Embedded","tags":["self-host","permissive","active"],"capabilities":["sqlite","embedded"],"surfaces":["Self-host"],"ecosystem":["Multi-platform","Rust"],"licenseModel":"OSS/MIT","githubStars":17279,"starsPerWeek":82,"access":"free","archived":false,"repo":{"createdAt":"2022-09-29","pushedAt":"2026-10-17","license":"MIT","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/libsql","html":"/gems/libsql","markdown":"/gems/libsql.md"}},{"slug":"rqlite","name":"rqlite","tagline":"MIT distributed, fault-tolerant SQLite over Raft","category":"databases","url":"https://rqlite.io","github":"https://github.com/rqlite/rqlite","pricing":"open-source","hook":"rqlite is a lightweight distributed relational database built on SQLite and Raft — think etcd, but with full SQL — shipped as a single binary you can cluster in seconds.","whatsGood":"MIT (rqlite/rqlite), release v10.6.1 (2026-10-16), developed since 2014. Full SQL via SQLite, including full-text search and JSON, loadable SQLite extensions such as vector search, atomic multi-statement requests, change data capture, and an HTTP API. A single binary with no external dependencies, plus Docker and Kubernetes options. ★~17.8k.","theCatch":"Writes 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.","verdict":"The easiest way to make SQLite highly available — great for config and critical small data.","addedAt":"2026-10-18","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"SQLite & Embedded","tags":["self-host","permissive","active"],"capabilities":[],"surfaces":["Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"OSS/MIT","githubStars":17807,"starsPerWeek":28,"access":"free","archived":false,"repo":{"createdAt":"2014-08-23","pushedAt":"2026-10-18","license":"MIT","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/rqlite","html":"/gems/rqlite","markdown":"/gems/rqlite.md"}}],"meta":{"total":6,"count":6,"offset":0,"limit":null,"sort":"curated","sorts":["curated","catalog","new","stars","trending","name"],"filters":{"subcategory":"sqlite-and-embedded"},"next":null,"categories":["agents","nextjs","python","shopify","databases","devops","design","observability","rust","payments","comms","notifications","libraries"],"tags":["mcp","cli","tui","api","sdk","desktop-app","web-ui","editor-plugin","self-host","local-first","free-tier","paid-only","paid-led","permissive","copyleft","source-available","license-unclear","coding-agents","local-llm","rag","memory","evals","browser-automation","scraping","sandbox","skills","voice","security","auth","payments","realtime","postgres","vector","kubernetes","containers","observability","testing","workflows","graphics-3d","git","active","stale","archived","young-repo","fast-stars"]}}