Get the latest tech news
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
Then, during checkpoint operations, the database pages are written from the WAL to the main DB file. I really don’t like that SQLite doesn’t throw any error on detection of corruption Since it automatically checkpoints every time, the data is lost too However, Pekka Enberg offered a different perspective that SQLite runs in embedded environments where there’s no server, and maybe core developers decided it may be better to limp along than crash.
Or read this on Hacker News