On 8 May 2015, at 6:54pm, Scott Perry <numist at apple.com> wrote: > If you're using wal mode journalling (which I'd recommend for running on iOS > devices), you'll want to execute `PRAGMA wal_checkpoint(TRUNCATE);` before > closing your last connection to ensure you don't leave any data behind in the > journal when you move the database file.
While the WAL journal file may not be deleted, I had understood that if all connections to a SQLite database were correctly closed, the database file would be completely up-to-date. The journal file would, presumably, contain only unused pages which hadn't been released. Simon.
