Safe in this context means not corrupting the database. You might lose data, but... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

JSR_FDED 15 days ago | parent | context | favorite | on: SQLite in Production: Optimizing WAL Mode, Concurr...

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.

tnodir 15 days ago [–]

> 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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact