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

> Normal is still completely corruption safe in WAL mode, and means only WAL checkpoints have to wait for FSYNC.

I would consider data loss on crash to be "corruption", for sure. And synchronous=normal + journal_mode=WAL can lose data:

https://www.sqlite.org/pragma.html#pragma_synchronous

> A transaction committed in WAL mode with synchronous=NORMAL might roll back following a power loss or system crash.



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

Search: