Edgewall Software

Changes between Version 62 and Version 63 of PySqlite


Ignore:
Timestamp:
Mar 1, 2015, 1:44:01 AM (9 years ago)
Author:
Ryan J Ollos
Comment:

Reorganized warnings.

Legend:

Unmodified
Added
Removed
Modified
  • PySqlite

    v62 v63  
    4040=== The Pysqlite2 bindings
    4141
    42 PySQLite 1.0.x and SQLite2 are not supported.
     42'''Note:''' PySQLite 1.0.x and SQLite2 are not supported.
    4343
    4444Detailed information about older releases:
     
    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.
    5656 * You need ''2.3.3'' if you use Apache and `mod_cache`, see Pysqlite:#174.
    57  * The versions 2.5.2 to 2.5.4 have a bug that prevents upgrading from 0.11 to 0.12 (and possibly other breakage), so don't use any of those, see #9434.
     57
     58{{{#!div style="border: 1pt dotted; margin: 1em"
     59**Version 2.5.2 - 2.5.4 Warning:** A known bug in pysqlite versions 2.5.2-4 prohibits upgrades of Trac databases from 0.11.x to 0.12. Please use versions 2.5.5 and newer or 2.5.1 and older. See #9434 for more detail.
     60}}}
     61
     62{{{#!div style="border: 1pt dotted; margin: 1em"
     63**Mac OS X Warning:** the Apple-supplied SQLite contains additional code to support file locking on network filesystems like AFP or SMB. This is not presently (3.3.6) in the mainline sources, so if you build your own SQLite from source it will not function correctly on such filesystems - typically it gives the error "{{{database is locked}}}". [http://alastairs-place.net/blog/2006/07/10/sqlite-and-mac/ A patch] used to be available, but you're better off using the Apple supplied version (presently 3.1.3).
     64}}}
    5865
    5966==== Downloading Pysqlite
    6067
    61 The source tarballs for the versions listed above are available from the [https://pypi.python.org/pypi/pysqlite pysqlite site].
     68The source tarballs for the versions listed above are available from the [pypi:pysqlite pysqlite site].
    6269 
    6370==== Building Pysqlite
     
    6572The recommended way to build the SQLite bindings is to do a `static_build`, which will download the latest sqlite3 amalgamation file, build and link it inside the Pysqlite module:
    6673 
    67 {{{
    68 #!sh
     74{{{#!sh
    6975$ tar xvfz <version>.tar.gz
    7076$ cd <version>
     
    7480Your system may require the development headers. Without these you will get various GCC related errors when attempting to build:
    7581
    76 {{{
     82{{{#!sh
    7783$ apt-get install libsqlite3-dev
    7884}}}
    79 
    80 '''Users of Mac OS X please take care''': the Apple-supplied SQLite contains additional code to support file locking on network filesystems like AFP or SMB. This is not presently (3.3.6) in the mainline sources, so if you build your own SQLite from source it will not function correctly on such filesystems - typically it gives the error "{{{database is locked}}}". [http://alastairs-place.net/blog/2006/07/10/sqlite-and-mac/ A patch] used to be available, but you're better off using the Apple supplied version (presently 3.1.3).
    8185
    8286== Upgrading SQLite