PSA: SQLITE WAL CHECKSUMS FAIL SILENTLY AND MAY LOSE DATA

Summary from the TLDR Web Dev newsletter

SQLite's Write-Ahead Logging (WAL) mode, while offering checksums, silently drops valid data frames following a detected checksum error during index rebuilds after unclean shutdowns, potentially leading to data loss without any error notification.