Primary
sqlite3 ⚬⃕ᵖʸ｜Documentation｜1st｜20260605005430-00-⌔
sqlite3 — DB-API 2.0 interface for SQLite databases — Python 3.14.5 documentation
sqlite3— DB-API 2.0 interface for SQLite databasesSource code: Lib/sqlite3/
SQLite is a C library that provides a lightweight disk-based database that doesn’t require a separate server process and allows accessing the database using a nonstandard variant of the SQL query language. Some applications can use SQLite for internal data storage. It’s also possible to prototype an application using SQLite and then port the code to a larger database such as PostgreSQL or Oracle.
The
sqlite3module was written by Gerhard Häring. It provides an SQL interface compliant with the DB-API 2.0 specification described by PEP 249, and requires the third-party SQLite library.This is an optional module. If it is missing from your copy of CPython, look for documentation from your distributor (that is, whoever provided Python to you). If you are the distributor, see Requirements for optional modules.
This document includes four main sections:
- Tutorial teaches how to use the
sqlite3module.- Reference describes the classes and functions this module defines.
- How-to guides details how to handle specific tasks.
- Explanation provides in-depth background on transaction control.
See also:
https://www.sqlite.org
The SQLite web page; the documentation describes the syntax and the available data types for the supported SQL dialect.
https://www.w3schools.com/sql/
Tutorial, reference and examples for learning SQL syntax.
PEP 249 - Database API Specification 2.0
PEP written by Marc-André Lemburg.
Printed 2026-06-28.
(echo:: @ ᯤ)
Link to original
Secondary
• • •