PSA: SQLite WAL checksums fail silently and may lose dataThis 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. Whenever you make writes, they are first written to the WAL file. To make lookups faster, SQLite maintains an index called the WAL Index. Note that SQLite always checkpoints and truncates the WAL file on the last connection close.