How to upgrade sqlite3 in python 2.7.3 inside a virtualenv?
python, sqlite, virtualenv
Solution
The below works for me, but please comment if there is any room for improvement:
Activate the virtualenv to which you are going to install the latest `sqlite3`
Get the latest source of `pysqlite` package from google code: `wget http://pysqlite.googlecode.com/files/pysqlite-2.6.3.tar.gz`
Compile `pysqlite` from source and together with the latest `sqlite` database: `python setup.py build_static`
Install it to the site-packages directory of the virtualenv: `python setup.py install`
The above will actually install the `pysqlite` into `path-to-virtualenv/lib/python2.7/site-packages`, which is where all other pip-installed libraries are.
Now, I have the latest version of `sqlite` (compiled into `pysqlite`) installed within a virtualenv, so I can do: `from pysqlite2 import dbapi2 as sqlite`
Problem
There is a sqlite3 library that comes with python 2.7.3, but it is hardly the latest version. I would like to upgrade it within a virtualenv environment. In other words, the upgrade only applies to the version of python installed within this virtualenv. What is the correct way to do so?