Chapter 9. The Python Interface

Python is an interpreted object-oriented programming language that is portable across different platforms. Its popularity is due to a combination of its powerful features and the clarity and agility of its syntax. It is an ideal language for prototyping while still managing to keep the code readable and manageable.

You can access SQLite from Python by using the PySQLite module, available from http://pysqlite.sourceforge.net/. PySQLite provides an interface to SQLite compliant with the Python Database API Specification 2.0, so the programming interface should be familiar if you have used Python with another database in the past and should still be intuitive if not.

The Python Database API Specification can be found at http://www.python.org/peps/pep-0249.html.