I have a problem when opening a read-only database, which is a WAL-mode database.
When trying to open it in read-only mode, i.e. using file:test.sqlite?mode=ro, SHM and WAL file are created. That's unpleasant, but the actual problem is the two files don't get deleted when closing the database. Steps to reproduce (OS=Windows, SQLite=3.30.1): .open test.sqlite create table test (a integer primary key autoincrement); insert into test (a) values (null); select * from test; .quit Now set the read-only attribute to test.sqlite, and continue: .open file:test.sqlite?mode=ro select * from test; <-- creates wal and shm .quit Result: SHM and WAL files are kept. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users