Re: [sqlite] sqlite 3.22.0 read-only WAL mode clarifications

2018-02-10 Thread Leonard Lausen
Hey Simon, thanks for your clarification. > Will any of the processes accessing the database have write permission > ? If not, if they're all just reading the existing database, then > there's no opportunity for corruption. Think of it as All of the processes (on "main" and remote host) have rea

Re: [sqlite] sqlite 3.22.0 read-only WAL mode clarifications

2018-02-10 Thread Simon Slavin
On 10 Feb 2018, at 7:07am, Leonard Lausen wrote: > thanks for your clarification. You're welcome. A couple of things you wrote make me think I phrased things poorly so I'm just taking this opportunity to illustrate what I wrote. >> Will any of the processes accessing the database have write p

Re: [sqlite] sqlite 3.22.0 read-only WAL mode clarifications

2018-02-09 Thread Simon Slavin
On 9 Feb 2018, at 10:50am, Leonard Lausen wrote: > sqlite 3.22.0 added the ability to read from WAL mode databases even if > the application lacks write permission on the database and its > containing directory, as long as the -shm and -wal files exist in that > directory. > > Even though the

Re: [sqlite] sqlite 3.22.0 read-only WAL mode clarifications

2018-02-09 Thread Richard Hipp
On 2/9/18, Leonard Lausen wrote: > sqlite 3.22.0 added the ability to read from WAL mode databases even if > the application lacks write permission on the database and its > containing directory, as long as the -shm and -wal files exist in that > directory. > > Even though the wiki page states tha

[sqlite] sqlite 3.22.0 read-only WAL mode clarifications

2018-02-09 Thread Leonard Lausen
sqlite 3.22.0 added the ability to read from WAL mode databases even if the application lacks write permission on the database and its containing directory, as long as the -shm and -wal files exist in that directory. Even though the wiki page states that WAL does not work over a network filesystem