{"data":{"slug":"sqlite","name":"SQLite","tagline":"The most deployed database in the world","category":"databases","categoryName":"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","capabilities":[],"surfaces":["Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"OSS/MIT","githubStars":null},"related":[{"slug":"supabase","name":"Supabase","tagline":"Open-source Firebase alternative built on Postgres"},{"slug":"turso","name":"Turso","tagline":"SQLite at the edge with libSQL"},{"slug":"redis","name":"Redis","tagline":"The in-memory data store everyone uses"},{"slug":"upstash","name":"Upstash","tagline":"Serverless Redis and Kafka"},{"slug":"pinecone","name":"Pinecone","tagline":"Vector database for AI applications"}],"links":{"self":"/api/gems/sqlite","html":"/gems/sqlite","markdown":"/gems/sqlite.md","category":"/api/gems?category=databases","categoryPage":"/stacks/databases"}}