Edgewall Software

Changes between Version 3 and Version 4 of PySqlite


Ignore:
Timestamp:
Dec 29, 2005, 5:24:26 AM (15 years ago)
Author:
Peter Bruin
Comment:

Added information on how to upgrade to SQlite3.x

Legend:

Unmodified
Added
Removed
Modified
  • PySqlite

    v3 v4  
    2626get by default on non-windows platforms, you face the risk to get
    2727persistent database locks (see #2170).
     28
     29
     30== Upgrading SQLite from 2.x to 3.x ==
     31The following information is copied from http://dev.ctor.org/pkcs1/wiki/TracUpgrade
     32
     33The database formats used by SQLite 2.x and sqlite 3.x are incompatible. If you upgrade your SQLite version (this can  also happen implicitly if you upgrade from PySQLite 1.0.x to 1.1.x or 2.x), then you must convert your database.
     34
     35To do this, install both SQLite 2.8 and SQLite 3.x  (they have different filenames so can coexist in the same directory). Then use the following commands (Windows):
     36{{{
     37 $ mv trac.db trac2.db
     38 $ sqlite trac2.db .dump | sqlite3 trac.db
     39}}}
     40
     41Then when you're happy with the conversion and tested everything  you can delete the trac2.db file.
     42
     43For more information see http://www.sqlite.org/version3.html