Re: [sqlite] CLI option to NOT autocheckpoint WAL databases

2017-06-01 Thread Howard Kapustein
>> Is it possible to use the CLI to read a WAL database and exit without >> modifying the database? >> >The checkpoint-on-close feature is not affected by >PRAGMA wal_autocheckpoint. The NO_CKPT_ON_CLOSE DB config flag is the >only mechanism to prevent it from inside the connection. SQLITE_API

Re: [sqlite] CLI option to NOT autocheckpoint WAL databases

2017-05-29 Thread Rowan Worth
On 29 May 2017 at 14:46, Clemens Ladisch wrote: > Howard Kapustein wrote: > > I'm effectively looking for a -readonly option, or how to achieve that > > net effect > > sqlite3 "file:test.db?mode=ro" > > But if you want to be really sure, set the file permissions to disallow >

Re: [sqlite] CLI option to NOT autocheckpoint WAL databases

2017-05-29 Thread Clemens Ladisch
Howard Kapustein wrote: > Is it possible to use the CLI to read a WAL database and exit without > modifying the database? The checkpoint-on-close feature is not affected by PRAGMA wal_autocheckpoint. The NO_CKPT_ON_CLOSE DB config flag is the only mechanism to prevent it from inside the

Re: [sqlite] CLI option to NOT autocheckpoint WAL databases

2017-05-28 Thread Simon Slavin
On 29 May 2017, at 5:33am, Howard Kapustein wrote: > Is it possible to use the CLI to read a WAL database and exit without > modifying the database? I don’t know about the database file itself. I think that one is only read unless you explicitly do writing.