The OP wanted something to check his systems for corruption - if the SQLite dev team don't want to add checksums then the OP could possibly solve his own problem by adding them to his own internal version.
Extension may have been a bad choice of word - he can modify/compile his own version of SQLite add checksums - and also add a corruption engine if he wants. 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 29 June 2016 at 22:10, Dominique Devienne <ddevie...@gmail.com> wrote: > On Wed, Jun 29, 2016 at 9:54 PM, Paul Sanderson < > sandersonforens...@gmail.com> wrote: > >> As mentioned above there is (or can be) reserved space at the end of >> each page (documented in the DB header) that can be used for checksums >> - you just need to write your own extension :) >> >> https://www.sqlite.org/fileformat2.html > > > Can you really? What kind of extension? > > The pager is not an extension point. > > The VFL is one, but https://www.sqlite.org/c3ref/io_methods.html is byte > oriented, not page oriented. > Plus there are different types of pages, with different format. Does the > checksum go in the same place for all them? > Official SQLite would ignore the extra info, and probably either not > rewrite it, or keep it as-is, when modifying a page, > making the page appear invalid. This is precisely the kind of things that > if not built in is kinda useless I'm afraid. > > Plus w/o a format change, even if built-in to the latest SQLite, older > SQLite apps wouldn't keep the checksums up-to-date too. > This and index-based-row-counts and probably other things do require a > backward-incompatible change IMHO. --DD > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
