Installing python-sqlite on Woody

Woody doesn't yet include python-sqlite, so on Woody you must install pysqlite manually:

lynx 
http://heanet.dl.sourceforge.net/sourceforge/pysqlite/pysqlite-0.5.0.tar.gz]
tar -xvzf pysqlite-0.5.0.tar.gz
cd pysqlite
python setup.py build

Possible problem:

1.

UserWarning: Unknown distribution option: 'classifiers'

Workaround: edit the file setup.py and modify line 61 to look for 2.2.4 instead of 2.2.3:

# patch distutils if it can't cope with the "classifiers" keyword
if sys.version < '2.2.4':


2.

_sqlite.c:30:20: sqlite.h: No such file or directory



python setup.py build 2> tmp.lst
less tmp.lst


Solution : you must also install the following debian packages:

libsqlite-dev - SQLite development files

libsqlite0 - SQLite shared library