-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/02/12 09:12, Michael Stephenson wrote: > It's almost trivial to add per-page checksums at the page level.
You omitted the steps of extensive testing and documentation :-) > Given the above, would per-page checksums be better served up as an > extension, rather than written into the core database code? I'd want it in the core because it would get the other details right. For example the write version can be bumped which would ensure SQLite versions without this functionality would not write to the database. I'd also want a pragma added to control turning it on/off which likely would also involve a vacuum to rewrite the pages. Finally I'd also want the full integrity check to actually read and check every page. Or in other words, a more complete implementation is possible when written into the core. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk8xX3kACgkQmOOfHg372QRRSgCdEQmyYXVruKCc20Fs+eQfra4y riYAn0J666Fca3JmckTn6v4Jxn6ACmwa =SZXl -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users