SQLite in Production: Lessons from Running a Store on a Single File (ultrathink.art)

The article describes running a production e-commerce store with Rails 8 using SQLite across four database files stored on a shared Docker volume, highlighting WAL mode and practical configuration details. It recounts a failure where rapid blue-green deploys overlapped and concurrent writers corrupted the expected order records—payments succeeded but two orders were missing. The author traces the issue to deployment pipeline concurrency on the shared volume, shares debugging tips (including sqlite_sequence), and lists SQLite-specific gotchas before concluding SQLite is viable with careful deploy pacing and moderate write loads.