[Trac] Trac and sqlite3

[Tristan Seligmann]

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).

> Can someone please outline what steps I need to take to ensure that my trac
> projects use sqlite3 successfully?

You would have to rebuild the python-sqlite package yourself, but
changing the build process to link against the sqlite 3 library (in
libsqlite3-0).

> (I'm assuming there *is* a performance benefit to using sqlite3 ... Right?)

I don't know anything about how they compare performance-wise.
-- 
Tristan Seligmann
Software Architect / Network Administrator