Mastodawn

SQLite in Production: Lessons from Running a Store on a Single File

https://ultrathink.art/blog/sqlite-in-production-lessons

SQLite in Production: Lessons from Running a Store on a Single File | ultrathink.art Blog

We run a production Rails store on SQLite — not Postgres, not MySQL. A single file on a Docker volume. It works surprisingly well until two containers try to...

ultrathink.art

Show thread

Kees N ✅🔻

@CuratedHackerNews
> "Backups are cp production.sqlite3 backup.sqlite3"
No, don't do that. There could still be committed transaction on the WAL. Better use the backup API, or "VACUUM INTO 'backupfile' "