On 1 Apr 2015, at 12:16am, MM <finjulhich at gmail.com> wrote: > Is all I need to do: PRAGMA journal_mode=WAL; once from sqlite3 command > line?
Yes. Just do it once, from any connection or any program. The mode is stored inside the database file and will then be used by any program which opens a connection. > 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? You need to share the folder that the dbfile is in, rather than trying to share specific files. SQLite can make and destroy ancillary files (journal, temp-index, etc.) any time it wants, and if you're using WAL mode, they should all be deleted by the time you close your last connection to the database. There's no way to ensure concurrency through git. Just ensure that you take your git 'copy' when the database isn't open. That should give it a 'clean' database file and no ancillary files. Simon.
