SQLite Forum

readonly access to WAL database
Login
Looks like the problem is that I was defaulting to `locking_mode = EXCLUSIVE`. If I open the database `-readonly` but then do `pragma locking_mode=normal;`, it works as expected.

(But then a -shm file is created, so I expect this wouldn't work if that file didn't already exist and the sqlite process didn't have permissions to create it.)