PSA: SQLite WAL checksums fail silently and may lose data - blag
This is a follow-up post to my PSA: SQLite does not do checksums and PSA: Most databases do not do checksums by default. In the previous posts I mentioned that SQLite does not do checksums by default, but it has checksums in WAL mode. However, on checksum errors, instead of raising error, it drops all the subsequent frames. Even if they are not corrupt. This is not a bug; it’s intentional.SQLite introduced WAL in 2010. It’s not the default mode, but you’re likely using it if you want higher writ...
Read more at avi.im