Here are some interesting things that I learned about #sqlite WAL mode this morning while debugging a #GeoPackage issue:
+ #QGIS opens GeoPackages in WAL mode
+ WAL mode persists, so subsequent connections from any application will be in WAL mode
+ Calling `PRAGMA journal_mode=DELETE;` turns off WAL mode and cleans up `-wal` and `-shm` files
+ WAL mode does not work across network file systems (or, in my case, between #WSL and Windows)
The docs are worth reading: