How to upgrade your Python's SQLite module

I talked with the support via a ticket, solved the problem and they encouraged me to post the answer here so that other WebFaction customers searching the community OSQA forum would benefit from it.

All the steps I went through are described here: http://blog.rodolfocarvalho.net/2012/07/upgrade-sqlite-version-python-webfaction.html

Basically:

$ wget http://pysqlite.googlecode.com/files/pysqlite-2.6.3.tar.gz

$ tar xf pysqlite-2.6.3.tar.gz

$ cd pysqlite-2.6.3

$ python2.7 setup.py build_static

$ mkdir -p $HOME/lib/python2.7

$ PYTHONPATH=$HOME/lib/python2.7 python2.7 setup.py install --home=$HOME

Optionally, override Python's standard sqlite3 module:

$ echo "from dbapi2 import *" >> $HOME/lib/python2.7/pysqlite2/__init__.py

$ ln -s $HOME/lib/python2.7/{pysqlite2,sqlite3}