SQLite on Rails: Everything you need to know
summary
Claims that SQLite can run production Rails apps once tuned, and a one‑liner script now configures it: it installs active_record_enhance_sqlite3_adapter to avoid busy errors and reimplements busy timeouts to release the GVL, wires up separate SQLite DBs for solid_q/cache/cable (4–7 DBs), and adds lightream backups plus a verification job. Benchmarks show ~10× faster than local Postgres and 500–1000× vs remote, and P99.99 latency falls under ~500ms after fixes; the repo is public and the tooling demonstrably works.
AI-written summary · about
chapters (10)
- 0:00Introduction to SQLite on Rails
- 3:36Why SQLite for Rails
- 8:10Challenges with SQLite in Rails
- 14:16Introducing the Enlightenment script
- 18:29Solving SQLite performance issues
- 27:22Solid gems and SQLite
- 31:42Data backups with Litestream
- 36:54Error monitoring with Solid Errors
- 39:29Miscellaneous SQLite tips
- 44:01Conclusion and resources
related talks
01h 07mHow (and why) to run SQLite in production
01h 56mSQLite on Rails: From rails new to 50k concurrent users and everything in between
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
30mUse SQLite in production
45mTips and Tricks for Tweaking and Using Ruby and Rails...
24mFrom Expensive Queries to Smart Caching: A DBA’s Guide for Rails
23mFANTASTIC DATABASES AND WHERE TO FIND THEM