SQLite is a very small RDBMS, unlike other popular RDBMS it does not have a client/server model, data is stored in a file. SQLite is very portable, and very popular for creating prototype systems before actual work is started. Here, we'll see how to access & modify SQLite database in Python. Python version >= 2.5 have the sqlite Python library shipped with core Python package, lower versions have to install the SQLite Python library pysqlite from http://code.google.com/p/pysqlite/

If you would like to manage the SQLite databases, you can install the sqlite3 command line tool, or a GUI in the form of a Firefox extension named SQLite Manager is also available.