-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 raf wrote: > i also needed the ability to restore an sqlite3 database > after a corruption.
What exactly are you doing that corrupts the database in the first place? If the machine you are using is randomly corrupting data then having your own journal won't help that much! If you are doing things like turning synchronous off then it is easier to have two database files (use ATTACH). Have one be the defaults (ie correctness, no corruption) at the expense of speed and the second be turned for speed at the expense of possible corruption. You can copy the data back and forth as necessary. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkhGJgACgkQmOOfHg372QRtLACbBSRJL5I2F7MNiJbQOWufavhx a4YAn0ji1eUJI2cGg5Qo0ZwAOiZTOBoq =xOxr -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users