Skip to main content

Search

Items tagged with: GeoPackage


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

This website uses cookies to recognize revisiting and logged in users. You accept the usage of these cookies by continue browsing this website.