[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Database corruption on Linux ext3
From:       Simon Slavin <slavins () bigfraud ! org>
Date:       2010-07-13 23:57:38
Message-ID: 6684BBB1-23AF-40C6-A78E-865BF3E9D496 () bigfraud ! org
[Download RAW message or body]


On 13 Jul 2010, at 9:26pm, Roger Binns wrote:

> 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?

One on each page and one for the entire file that checksums the page checksums ?  \
I've seen that done elsewhere.  Perhaps instead one for each thing that needs its own \
pages (e.g. one for each table and index).  Or just one for each table which includes \
the index data in with it.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[prev in list] [next in list] [prev in thread] [next in thread]