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
