SQLite WAL mode gotcha

If you’re running SQLite in WAL mode on a network filesystem (NFS, SMB), you’re going to have a bad time. WAL requires shared-memory primitives (mmap) that don’t work correctly over network mounts. The database will silently corrupt.

Local disk or bust. This is documented but easy to miss when you’re mounting a NAS volume into a container.