Edgewall Software

Changes between Version 63 and Version 64 of PySqlite


Ignore:
Timestamp:
Jul 20, 2015, 8:32:18 AM (4 years ago)
Author:
figaro
Comment:

Cosmetic changes

Legend:

Unmodified
Added
Removed
Modified
  • PySqlite

    v63 v64  
    11= PySqlite
    22
    3 [https://pypi.python.org/pypi/pysqlite PySqlite] is a Python binding for the [http://www.sqlite.org SQLite] light-weight database engine, which is Trac's default DatabaseBackend.
     3[pypi:pysqlite PySqlite] is a Python binding for the [http://www.sqlite.org SQLite] light-weight database engine, which is Trac's default DatabaseBackend.
    44
    55== Installation
    66=== The short version
    77
    8 If you're using Python 2.5 and up, you already have a working version of pysqlite 2, bundled as `sqlite3`.
    9 
    10 If you are using an older version of Python or you'd like to benefit from the latest version of pysqlite, grab Windows installer or the source .tar.gz from the official [https://pypi.python.org/pypi/pysqlite pysqlite site].
     8If you are using Python 2.5 and up, you already have a working version of pysqlite 2, bundled as `sqlite3`.
     9
     10If you are using an older version of Python or you would like to benefit from the latest version of pysqlite, grab Windows installer or the source .tar.gz from the official [https://pypi.python.org/pypi/pysqlite pysqlite site].
    1111
    1212If you need to build from this .tar.gz, simply do after unpacking:
     
    1616This will fetch the latest SQLite version and bundle it within the extension.
    1717
    18 [[PageOutline(2-4)]]
     18[[PageOutline(2-4,Contents,pullout)]]
    1919
    2020=== The SQLite library
     
    4343
    4444Detailed information about older releases:
    45  * Trac 0.12.x requires a PySqlite 2.x release 
     45 * Trac 0.12.x requires a PySqlite 2.x release:
    4646   * version >= 2.0.5 preferred,
    4747   * 2.0.3 has been reported to cause crashes on Windows (#2688)
     
    5454   are working perfectly)
    5555 * The ''2.3.2'' version is the one which ships with Python 2.5, available there as the `sqlite3` package. Trac tries to use it if the `pysqlite2` package is installed.
    56  * You need ''2.3.3'' if you use Apache and `mod_cache`, see Pysqlite:#174.
     56 * You need the ''2.3.3'' version if you use Apache and `mod_cache`, see Pysqlite:#174.
    5757
    5858{{{#!div style="border: 1pt dotted; margin: 1em"
     
    8585
    8686== Upgrading SQLite
     87
    8788=== Upgrading SQLite from 2.x to 3.x
    8889
     
    145146==== `OperationalError: unsupported file format`
    146147
    147 ''This probably is symptomatic of a mismatch between the SQLite library and the SQLite database format.''
    148 
    149 See Trac-ML:7540
     148This probably is symptomatic of a mismatch between the SQLite library and the SQLite database format. See Trac-ML:7540.
    150149
    151150And this might be caused by a different version of PHP's pdo_sqlite module when you use Trac in mod_python mode. Check your pdo_sqlite module's version, or if OK, you may simply disable it, see `/etc/php.d/pdo_sqlite.ini`. Note that sqlite 3.3.x and 3.2.x are not compatible.
     
    153152==== `DatabaseError: file is encrypted or is not a database`
    154153
    155 There are typically three situations in which this somewhat ''cryptic'' error message can be seen:
    156  - when trying to modify the database file and the '''write''' permission is missing; fix the permissions
     154There are typically three situations in which this somewhat cryptic error message can be seen:
     155 - when trying to modify the database file and the '''write''' permission is missing; fix the permissions.
    157156 - when accessing a SQLite 2.x database file with a SQLite 3.x library; see [#UpgradingSQLitefrom2.xto3.x above] for the upgrade instructions.
    158157 - when accessing a database that has been created in or explicitly converted to WAL mode, using a version of SQLite older than 3.7.0, ie with no WAL support; upgrade your bindings to use a recent SQLite.