Roger Binns wrote: >> Writing to the beginning of the file (the first 40 bytes >> or so) corrupts the database so badly that SQLite can't >> even execute the pragma. > > The header contains a signature for the file and important meta > information which make the file useless if they are wrong. See > http://www.sqlite.org/fileformat.html#tocentry_71 > Great document! I wasn't aware that it existed. Thanks!
> That said, if you are using a system that random corrupts files then > your problems are far larger than SQLite. How do you deal with other > data being corrupted, or even ensure that the programs you run aren't > messed with? > We're confident of our file system, because we've never had any problems with it. However, we have seen some nasty data corruption problems with our current database system, which we hope to eliminate by converting to SQLite. - Richard Klein _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
