This article describes how to connect to a SQLite database using Python.
Connecting to SQLite using Python
The sqlite3 module is part of Python’s standard library, and includes all of the functionality you need to access and work with SQLite databases. You do not need to install any vendor-specific modules to work with SQLite in Python.
The following sample code demonstrates how to connect to a SQLite database using the sqlite3 module and how to do some basic data manipulation. The code works with Python 2.7 and Python 3.x:
In this example, we first create a Connection object that opens the SQLite database. If the test.db file already exists, Python opens that file. Otherwise, Python creates a new database in the test.db file.
After we have a Connection object associated with the database, we can create a Cursor object. The Cursor object enables us to run the execute() method, which in turn enables us to run raw SQL statements (such as CREATE TABLE and SELECT).
Finally, we call the close() method to close the connection to the database.
If you modify any database contents (as in the example above), you must call the commit() method to save the changes to the database file.
Related articles
