SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. While pysqlite is a Python DB-API 2.0 interface for it. So in order to install pysqlite you have to have sqlite installed. But unfortunately when trying to install sqlite using apt-get it seems that some header files were missing that prevented pysqlite from being installed properly. So after installing sqlite from source, I was able to install pysqlite successfully.
Tags: SQLIte, Debian, Gr33n Data