1
PSA: SQLite WAL checksums fail silently and may lose data
SQLite WAL has checksums, but on corruption it drops all the data and does not raise error
v: Go and Rust programmer from India.
Visit avi.im → On Hacker News Jul 2021 – Sep 2025
Databases & Data 8Systems & Performance 4Security & Privacy 2Software Engineering 2Programming Languages 1History & Retro Computing 1
SQLite WAL has checksums, but on corruption it drops all the data and does not raise error
SQLite does not do checksums by default. Disk corruptions go silently unnoticed.