3 ms·
> 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 "cor
by yencabulator 4y ago
> 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 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.