-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/13/2010 12:59 PM, D. Richard Hipp wrote: > You are encouraged to submit comments, insights, criticism, and > analysis to this mailing list. Thanks.
Have you considered adding internal checksums to SQLite files so that at the very least corruption can be detected? I think this is one of the best features of the current crop of version control systems. IIRC one of the original papers describing ZFS claimed an undetected error rate of once every 20TB of activity with hard drives. That is not an unreasonable amount of disk access in one day now. Errors could of course instead be detected by using better filesystems, drives, protocols etc, but we often don't have the luxury of dictating what systems SQLite databases will be used on. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkw8y/IACgkQmOOfHg372QTWfgCgjcPCvOLQuPv1Xqc6XM3TkXLY X80An2TFiktmQxOY0sMxO1VLD74YzYpX =tJ9V -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
