News for hackers. Stuff that matters.
Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a... by JSR_FDED on Wednesday July 29, 2026 @09:57AM (#49097623)
Safe in this context means not corrupting the database. You might lose data, but the database will live on happily as if the missing data was never written to it. You don’t get half-committed transactions, and the database isn’t in a weird state.
Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a... by tnodir on Wednesday July 29, 2026 @10:18AM (#49097884)
> even if the server crashes, only the uncommitted transactions in the WAL are lost

I'm mainly referring to this quote.

So, you can lose committed transactions too.