[infamia]

Using WAL2 should make that problem better. It has two WAL files it alternates between when making writes, so the system has an opportunity to check point the WAL file not in use.

https://sqlite.org/src/doc/wal2/doc/wal2.md