sqlite3 | Python Standard Library – Real Python
The Python sqlite3 module provides an interface for interacting with SQLite databases, which are lightweight, serverless, and self-contained. This module allows you to effortlessly create, manage, and query SQLite databases from Python code.
Here’s a quick example:
Key Features
- Connects to SQLite databases stored in files or in-memory
- Executes SQL queries and fetches results
- Supports transactions and provides a context manager interface
- Allows for the creation of custom SQLite functions in Python
- Supports dictionary-like row access with
sqlite3.Row
Frequently Used Classes and Functions
Examples
Connecting to an SQLite database and creating a table:
Inserting data into a table:
Querying data from a table:
Handling errors and transactions:
Using executemany() to insert multiple rows:
Common Use Cases
- Storing application data in a local database
- Prototyping and testing SQL queries
- Creating lightweight, portable data storage solutions
Real-World Example
Suppose you want to manage a contact list. You can use the sqlite3 module to create a database, add contacts, and retrieve them quickly:
This example demonstrates how the sqlite3 module can be used to store and manage contact information in a local SQLite database.
For additional information on related topics, take a look at the following resources: