SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
For Python versions < 2.5, you will need the third-party pysqlite module. In Python >= 2.5, pysqlite is already integrated in the standard library as sqlite3, but it may be an older version than the current pysqlite. Make sure you have a recent version installed.
Use your package manager
For Darwin Ports:
$ sudo port install sqlite2
For multiuser applications with heavy load you should use use MySQL or PostgreSQL instead, otherwise you’ll probably often get the error “database locked”, because concurrent threads are trying to access the database for writing at the same time.
If you are getting this error:
exceptions.AttributeError: "'pysqlite2.dbapi2.Connection' object has no attribute 'autocommit'"