This is configurable, and for small things you might disable WAL completely. Whe...

		ricardobeat on Jan 15, 2024 \| parent \| context \| favorite \| on: SQLite: Wal2 Mode This is configurable, and for small things you might disable WAL completely. When using WAL, if you’re copying or backing up the database it’s possible to force a checkpoint, then you can copy the .db file alone knowing exactly up to when it contains data.

I had to learn all that the hard way ;)