16y old sqlite wal reset bug was caught

[hpvd]

interesting story:
https://tailscale.com/blog/sqlite-wal-reset-bug

In particular, if a write occurs at a specific time during a checkpoint, the checkpointing process gets confused—it thinks some of the pages have been copied from the WAL into the main database file, but they haven’t. Those pages never get written to the database file, and that data is permanently lost. The database file becomes corrupt, because other pages which reference those pages—such as an index—are written to the database.

would be interesting if turso works fine in this field, because deterministic testing found it..