>> 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
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
>
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
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.
4 matches
Mail list logo