[Trac] Trac and sqlite3

[Christopher Lenz]

> Clay Loveless wrote:
> > I'm run mod_python on a Debian Sarge server that has sqlite (2) and
> > sqlite3 packages installed. It appears that trac does not choose 
> > between the two if both are available, but rather goes with sqlite 2 
> > by default.
> 
> This is because the python-sqlite package is built against the sqlite
> 2.x library (in libsqlite0).

Actually, I think it's just a matter of choosing between pysqlite <= 1.0.x  
and pysqlite >= 1.1.x. The latter uses the SQLite 3 APIs, while the former 
uses SQLite 2.

This has the side-effect that you can't have both SQLite 2 and 3 Trac 
environments on the same machine (without some hacking), because the 
choice is made by which pysqlite version Trac finds on the Python path.

Cheers,
Chris

-- 
Christopher Lenz
  cmlenz at gmx.de
  http://www.cmlenz.net/