SQLite, the World's Most Ubiquitous Yet Little-Known Database
summary
Describes migrating multiple REST APIs to SQLite as the primary backend for a small SaaS in 2023, reporting production handling of ~100 requests/sec and benchmarks up to tens of thousands/sec. Uses WAL journaling to avoid reader/writer contention, relies on Litestream to replicate WAL to S3 or periodic point-in-time backups for durability, and discusses trade-offs: single-writer limitations, limited typing (no exact decimal type), no built-in database users, and a memory mode with point-backup for fast tests and startup.
AI-written summary · about
chapters (7)
- 0:00Introduction et parcours
- 3:10Présentation de SQLite
- 7:23Avantages de SQLite
- 11:57Cas d'usage et performances
- 17:10Limitations et solutions
- 21:43Astuces pratiques
- 28:46Conclusion et ressources
related talks
19mSQLite - The most overlooked database
30mUse SQLite in production
01h 56mSQLite on Rails: From rails new to 50k concurrent...
01h 56mSQLite on Rails: From rails new to 50k concurrent users and everything in between
01h 07mSQLite
01h 07mHow (and why) to run SQLite in production
24mgives databases to everyone
23mFANTASTIC DATABASES AND WHERE TO FIND THEM