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:

https://sqlite.org/wal.html