#wal
-
Tailscale traced a database corruption bug to a 16-year-old flaw in SQLite
Tailscale's engineers traced a rare database corruption down to a bug in SQLite's WAL reset mechanism that had existed for about sixteen years.
-
SQLite's WAL Mode Can Lock Out Short-Lived Readers
Hynek Schlawack ran into a “database is locked” error on an SQLite database that almost never gets written to, and found the culprit in WAL mode, where even reading implies writing.