Changes between Version 58 and Version 59 of PySqlite

Timestamp:

Feb 26, 2015, 9:11:18 PM (9 years ago)

Author:

Ryan J Ollos

Comment:

Simplify how to get SQLite and PySQLite versions.

PySqlite

@@ -76 +76 @@
 }}}
 
+Your system may require the development headers. Without these you will get various GCC related errors when attempting to build:
+
+{{{
+$ apt-get install libsqlite3-dev
+}}}
+
 '''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).
 
@@ -110 +116 @@
 === Determine actual SQLite and PySqlite version
 
-Troubleshooting is greatly helped by knowing exactly what versions are used for {{{sqlite}}} inside your Python interpreter. Especially on *nix systems different versions might exist and the actual versions linked and used might not be what you think.
-
-To test the version of PySqlite what your Python installation uses and the version of SQLite linked, try this inside an interpreter:
-{{{
->>> import sqlite
->>> sqlite.version
-'1.0.1'
->>> sqlite._sqlite.sqlite_version()
-'2.8.16'
-}}}
-
-To ensure that this is the exact version Trac uses, you may try this: 
-
-{{{
-#!python
->>> import trac.db.sqlite_backend as sql
->>> sql.sqlite_version
-(3, 7, 5)
->>> sql.have_pysqlite
-2
->>> sql.sqlite.version
-'2.6.0'
-}}}
-
-In other words, PySqlite is version 2.6.0, compiled and linked to use version SQLite 3.7.5.
+The SQLite and PySqlite versions are displayed on the //About Trac// page for users that have the `CONFIGURATION_VIEW` permission.
+
+=== Test that bindings are imported
 
 Another way to test the bindings with PySqlite 2 is to use:
@@ -142 +126 @@
 
 This test should not fail.
-
-To install SQLite, your system may require the development headers. Without these you will get various GCC related errors when attempting to build:
-
-{{{
-$ apt-get install libsqlite3-dev
-}}}
 
 === Check if database is ok