[sqlite] WAL with linux and win

2015-04-01 Thread Simon Slavin
On 1 Apr 2015, at 12:16am, MM 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

[sqlite] WAL with linux and win

2015-04-01 Thread MM
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