Changes between Version 30 and Version 31 of PySqlite

Timestamp:

Sep 16, 2007, 11:47:53 AM (17 years ago)

Author:

ThurnerRupert

Comment:

—

PySqlite

@@ -126 +126 @@
 This test should not fail.
 
+=== Check if database is ok ===
+Sometimes vacuum helps to fix inconsistencies in the db. See also [http://www.sqlite.org/pragma.html pragma], [http://www.sqlite.org/sqlite.html command line], [http://www.sqlite.org/lang_vacuum.html vacuum].
+{{{
+$ sqlite3 trac-parent/mytracinstance/db/trac.db
+sqlite> PRAGMA integrity_check;
+... some errors ...
+sqlite> VACUUM;
+sqlite> PRAGMA integrity_check;
+ok
+}}}
+
 === Common ''Oops'' ===