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 functional demo licence On 11 November 2015 at 00:24, Richard Hipp <drh at sqlite.org> wrote: > On 11/10/15, Paul Sanderson <sandersonforensics at gmail.com> 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). >> > > The increment and randomization of the salts occurs at the start of > the next write transaction. (It is deferred until then to avoid > having to take unnecessary write locks.) > > The file format documentation is not technically wrong, but it is > misleading. I have updated that document now (see the second > paragraph of section 4.3 at https://www.sqlite.org/fileformat.html) to > try to make it less ambiguous. > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users