I have a sqlite3 3.8.8.2/3 database me.db. I access it from: 1. C++/odb (linux64/win64) in read only mode 2. python3 (linux64 server) in readonly mode from process 1 and read/write mode from process 2, concurrently. 3. python3/DB BrowserSQLite (win64 PC) in read/write mode, not concurrently.
I share the file through a git repository. I just realized my concurrency need in point 2., and discovered WAL. Is all I need to do: PRAGMA journal_mode=WAL; once from sqlite3 command line? Any further arguments when opening the db from sqlite3.connect in python, or from C++/odb ? How about win/linux dbfile travel through git? I understand 2 more files appear in WAL, the wal-index and the shmem file. I can't just share across the 2 boxes server and pc? Rds, MM
