[sqlite] howto shrink files in wal mode

[Richard Hipp]

On 5/5/15, Zaumseil Ren? <RZaumseil at kkg.ch> wrote:
>
> Is there a way to shrink the file when it is still open in WAL mode?
>

Run "PRAGMA wal_checkpoint=TRUNCATE;" in SQLite 3.8.8.2 or later.
-- 
D. Richard Hipp
drh at sqlite.org