sqlite3 Module

Python ships with a working SQL database built in. The sqlite3 module wraps the SQLite engine, which is a small C library that stores a whole database in a single file (or in memory). No server to install, no credentials to set up, no network port to open. That makes it the easiest way to learn SQL from Python and a strong pick for a long list of small but real applications. This lesson covers when SQLite is the right fit, how to open and use a connection, what cursors and row factories do, how to handle transactions, and where SQLite's quirks differ from heavier databases.