Richard implied in this bug that you can use locking_mode=exclusive when you have a single process using that database, but that process has multiple threads & connections:
https://bugzilla.mozilla.org/show_bug.cgi?id=993556 However, I've tried this and can't get it to work - the second open call that comes around will block. Am I misunderstanding the post, or just not getting the configuration right? I'm running: WAL / NORMAL. And my 2 sqlite3_open_v2 calls uses: SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_NOMUTEX | SQLITE_OPEN_PRIVATECACHE -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-use-multiple-connections-with-locking-mode-exclusive-tp78528.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users