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