[sqlite] Understanding WALs

2015-11-11 Thread Paul Sanderson
Thanks Richard a nice simple answer to pass on. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully

[sqlite] Understanding WALs

2015-11-10 Thread Paul Sanderson
I am trying to get my head around the operation of WAL files and an oddity that I can't explain. As I understand it when a transaction is committed when a DB is in WAL mode each changed page is appended to the WAL. Multiple transactions work in the same way until a checkpoint occurs. The WAL has

[sqlite] Understanding WALs

2015-11-10 Thread Richard Hipp
On 11/10/15, Paul Sanderson wrote: > > As the last thing I did was a wal-checkpoint then according to the > documentation the page should have been written to the DB (it was see > pic below of page two of the DB) AND the salts incremented and > randomised (section 4.3 of the file format page). >