On 11 Apr 2017, at 12:22am, Jens Alfke <j...@mooseyard.com> wrote: > It only states that the process must be able to create/write the -shm file. > It doesn't say anything about opening the database with SQLITE_OPEN_READONLY
The problem here is not whether you’re allowing SQLite to make changes to your data, but whether the OS is allowing SQLite to write to its files. You should regard SQLITE_OPEN_READONLY as telling SQLite whether it’s allowed to change the database. It doesn’t tell SQLite how it should work internally, just whether it’s allowed to execute commands like CREATE and UPDATE. Don’t try to open a database which has WAL mode set unless you have write permission to the database file, journal file and shared memory file. (Or create new files, then write to them). It may be that the documentation should be updated to reflect this. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
