René's URL Explorer Experiment

Title: sqlite3 — DB-API 2.0 interface for SQLite databases — Python 3.15.0a5 documentation

Open Graph Title: sqlite3 — DB-API 2.0 interface for SQLite databases

Description: Source 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 ...

Open Graph Description: Source 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 ...

Opengraph URL: https://docs.python.org/3/library/sqlite3.html

direct link

Domain: docs.python.org

og:type	website
og:site_name	Python documentation
og:image:width	1146
og:image:height	600
og:image	https://docs.python.org/3.15/_images/social_previews/summary_library_sqlite3_de021cde.png
og:image:alt	Source 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 ...
twitter:card	summary_large_image
theme-color	#3776ab
readthedocs-addons-api-version	1

Links:

	https://www.python.org/
Table of Contents	https://docs.python.org/dev/contents.html
sqlite3 — DB-API 2.0 interface for SQLite databases	https://docs.python.org/dev/library/sqlite3.html
Tutorial	https://docs.python.org/dev/library/sqlite3.html#tutorial
Reference	https://docs.python.org/dev/library/sqlite3.html#reference
Module functions	https://docs.python.org/dev/library/sqlite3.html#module-functions
Module constants	https://docs.python.org/dev/library/sqlite3.html#module-constants
Connection objects	https://docs.python.org/dev/library/sqlite3.html#connection-objects
Cursor objects	https://docs.python.org/dev/library/sqlite3.html#cursor-objects
Row objects	https://docs.python.org/dev/library/sqlite3.html#row-objects
Blob objects	https://docs.python.org/dev/library/sqlite3.html#blob-objects
PrepareProtocol objects	https://docs.python.org/dev/library/sqlite3.html#prepareprotocol-objects
Exceptions	https://docs.python.org/dev/library/sqlite3.html#exceptions
SQLite and Python types	https://docs.python.org/dev/library/sqlite3.html#sqlite-and-python-types
Default adapters and converters (deprecated)	https://docs.python.org/dev/library/sqlite3.html#default-adapters-and-converters-deprecated
Command-line interface	https://docs.python.org/dev/library/sqlite3.html#command-line-interface
How-to guides	https://docs.python.org/dev/library/sqlite3.html#how-to-guides
How to use placeholders to bind values in SQL queries	https://docs.python.org/dev/library/sqlite3.html#how-to-use-placeholders-to-bind-values-in-sql-queries
How to adapt custom Python types to SQLite values	https://docs.python.org/dev/library/sqlite3.html#how-to-adapt-custom-python-types-to-sqlite-values
How to write adaptable objects	https://docs.python.org/dev/library/sqlite3.html#how-to-write-adaptable-objects
How to register adapter callables	https://docs.python.org/dev/library/sqlite3.html#how-to-register-adapter-callables
How to convert SQLite values to custom Python types	https://docs.python.org/dev/library/sqlite3.html#how-to-convert-sqlite-values-to-custom-python-types
Adapter and converter recipes	https://docs.python.org/dev/library/sqlite3.html#adapter-and-converter-recipes
How to use connection shortcut methods	https://docs.python.org/dev/library/sqlite3.html#how-to-use-connection-shortcut-methods
How to use the connection context manager	https://docs.python.org/dev/library/sqlite3.html#how-to-use-the-connection-context-manager
How to work with SQLite URIs	https://docs.python.org/dev/library/sqlite3.html#how-to-work-with-sqlite-uris
How to create and use row factories	https://docs.python.org/dev/library/sqlite3.html#how-to-create-and-use-row-factories
How to handle non-UTF-8 text encodings	https://docs.python.org/dev/library/sqlite3.html#how-to-handle-non-utf-8-text-encodings
Explanation	https://docs.python.org/dev/library/sqlite3.html#explanation
Transaction control	https://docs.python.org/dev/library/sqlite3.html#transaction-control
Transaction control via the autocommit attribute	https://docs.python.org/dev/library/sqlite3.html#transaction-control-via-the-autocommit-attribute
Transaction control via the isolation_level attribute	https://docs.python.org/dev/library/sqlite3.html#transaction-control-via-the-isolation-level-attribute
dbm — Interfaces to Unix “databases”	https://docs.python.org/dev/library/dbm.html
Data Compression and Archiving	https://docs.python.org/dev/library/archiving.html
Report a bug	https://docs.python.org/dev/bugs.html
Show source	https://github.com/python/cpython/blob/main/Doc/library/sqlite3.rst?plain=1
index	https://docs.python.org/dev/genindex.html
modules	https://docs.python.org/dev/py-modindex.html
next	https://docs.python.org/dev/library/archiving.html
previous	https://docs.python.org/dev/library/dbm.html
Python	https://www.python.org/
3.15.0a5 Documentation	https://docs.python.org/dev/index.html
The Python Standard Library	https://docs.python.org/dev/library/index.html
Data Persistence	https://docs.python.org/dev/library/persistence.html
sqlite3 — DB-API 2.0 interface for SQLite databases	https://docs.python.org/dev/library/sqlite3.html
¶	https://docs.python.org/dev/library/sqlite3.html#module-sqlite3
Lib/sqlite3/	https://github.com/python/cpython/tree/main/Lib/sqlite3/
PEP 249	https://peps.python.org/pep-0249/
SQLite	https://sqlite.org/
optional module	https://docs.python.org/dev/glossary.html#term-optional-module
Requirements for optional modules	https://docs.python.org/dev/using/configure.html#optional-module-requirements
Tutorial	https://docs.python.org/dev/library/sqlite3.html#sqlite3-tutorial
Reference	https://docs.python.org/dev/library/sqlite3.html#sqlite3-reference
How-to guides	https://docs.python.org/dev/library/sqlite3.html#sqlite3-howtos
Explanation	https://docs.python.org/dev/library/sqlite3.html#sqlite3-explanation
https://www.sqlite.org	https://www.sqlite.org
https://www.w3schools.com/sql/	https://www.w3schools.com/sql/
PEP 249	https://peps.python.org/pep-0249/
¶	https://docs.python.org/dev/library/sqlite3.html#tutorial
cursors	https://en.wikipedia.org/wiki/Cursor_(databases)
transactions	https://en.wikipedia.org/wiki/Database_transaction
sqlite3.connect()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
con.cursor()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.cursor
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
flexible typing	https://www.sqlite.org/flextypegood.html
cur.execute(...)	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
The Schema Table	https://www.sqlite.org/schematab.html
cur.execute(...)	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
res.fetchone()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.fetchone
tuple	https://docs.python.org/dev/library/stdtypes.html#tuple
cur.execute(...)	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
Transaction control	https://docs.python.org/dev/library/sqlite3.html#sqlite3-controlling-transactions
con.commit()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.commit
cur.execute(...)	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
res.fetchall()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.fetchall
list	https://docs.python.org/dev/library/stdtypes.html#list
cur.executemany(...)	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executemany
string formatting	https://docs.python.org/dev/tutorial/inputoutput.html#tut-formatting
SQL injection attacks	https://en.wikipedia.org/wiki/SQL_injection
How to use placeholders to bind values in SQL queries	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
tuple	https://docs.python.org/dev/library/stdtypes.html#tuple
con.close()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.close
How-to guides	https://docs.python.org/dev/library/sqlite3.html#sqlite3-howtos
How to use placeholders to bind values in SQL queries	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
How to adapt custom Python types to SQLite values	https://docs.python.org/dev/library/sqlite3.html#sqlite3-adapters
How to convert SQLite values to custom Python types	https://docs.python.org/dev/library/sqlite3.html#sqlite3-converters
How to use the connection context manager	https://docs.python.org/dev/library/sqlite3.html#sqlite3-connection-context-manager
How to create and use row factories	https://docs.python.org/dev/library/sqlite3.html#sqlite3-howto-row-factory
Explanation	https://docs.python.org/dev/library/sqlite3.html#sqlite3-explanation
¶	https://docs.python.org/dev/library/sqlite3.html#reference
¶	https://docs.python.org/dev/library/sqlite3.html#module-functions
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
path-like object	https://docs.python.org/dev/glossary.html#term-path-like-object
SQLite database existing only in memory	https://sqlite.org/inmemorydb.html
float	https://docs.python.org/dev/library/functions.html#float
OperationalError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.OperationalError
int	https://docs.python.org/dev/library/functions.html#int
natively supported by SQLite	https://docs.python.org/dev/library/sqlite3.html#sqlite3-types
register_converter()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.register_converter
PARSE_DECLTYPES	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PARSE_DECLTYPES
PARSE_COLNAMES	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PARSE_COLNAMES
str	https://docs.python.org/dev/library/stdtypes.html#str
Connection.isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
Transaction control via the isolation_level attribute	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-isolation-level
Connection.autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
bool	https://docs.python.org/dev/library/functions.html#bool
ProgrammingError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
threadsafety	https://docs.python.org/dev/library/sqlite3.html#sqlite3.threadsafety
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
int	https://docs.python.org/dev/library/functions.html#int
bool	https://docs.python.org/dev/library/functions.html#bool
How to work with SQLite URIs	https://docs.python.org/dev/library/sqlite3.html#sqlite3-uri-tricks
bool	https://docs.python.org/dev/library/functions.html#bool
PEP 249	https://peps.python.org/pep-0249/
Connection.autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
Transaction control via the autocommit attribute	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-autocommit
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
auditing event	https://docs.python.org/dev/library/sys.html#auditing
auditing event	https://docs.python.org/dev/library/sys.html#auditing
path-like object	https://docs.python.org/dev/glossary.html#term-path-like-object
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.complete_statement
execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
Lib/sqlite3/__main__.py	https://github.com/python/cpython/tree/main/Lib/sqlite3/__main__.py
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.enable_callback_tracebacks
sys.stderr	https://docs.python.org/dev/library/sys.html#sys.stderr
unraisable hook handler	https://docs.python.org/dev/library/sys.html#sys.unraisablehook
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.register_adapter
callable	https://docs.python.org/dev/glossary.html#term-callable
type that SQLite natively understands	https://docs.python.org/dev/library/sqlite3.html#sqlite3-types
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.register_converter
callable	https://docs.python.org/dev/glossary.html#term-callable
bytes	https://docs.python.org/dev/library/stdtypes.html#bytes
connect()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
¶	https://docs.python.org/dev/library/sqlite3.html#module-constants
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
Transaction control via the isolation_level attribute	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-isolation-level
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PARSE_DECLTYPES
connect()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
PARSE_COLNAMES	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PARSE_COLNAMES
str	https://docs.python.org/dev/library/stdtypes.html#str
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PARSE_COLNAMES
connect()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
PARSE_DECLTYPES	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PARSE_DECLTYPES
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_OK
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DENY
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_IGNORE
callable	https://docs.python.org/dev/glossary.html#term-callable
Connection.set_authorizer()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.set_authorizer
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.apilevel
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.paramstyle
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.sqlite_version
string	https://docs.python.org/dev/library/stdtypes.html#str
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.sqlite_version_info
tuple	https://docs.python.org/dev/library/stdtypes.html#tuple
integers	https://docs.python.org/dev/library/functions.html#int
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_KEYWORDS
tuple	https://docs.python.org/dev/library/stdtypes.html#tuple
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.threadsafety
threading mode	https://sqlite.org/threadsafe.html
threadsafety	https://peps.python.org/pep-0249/#threadsafety
SQLITE_THREADSAFE	https://sqlite.org/compile.html#threadsafe
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_DEFENSIVE
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_DQS_DDL
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_DQS_DML
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_FKEY
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_QPSG
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_TRIGGER
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_VIEW
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_RESET_DATABASE
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_TRIGGER_EQP
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_TRUSTED_SCHEMA
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_WRITABLE_SCHEMA
Connection.setconfig()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.setconfig
getconfig()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.getconfig
https://www.sqlite.org/c3ref/c_dbconfig_defensive.html	https://www.sqlite.org/c3ref/c_dbconfig_defensive.html
¶	https://docs.python.org/dev/library/sqlite3.html#connection-objects
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
sqlite3.connect()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
Transaction control	https://docs.python.org/dev/library/sqlite3.html#sqlite3-controlling-transactions
How to use connection shortcut methods	https://docs.python.org/dev/library/sqlite3.html#sqlite3-connection-shortcuts
How to use the connection context manager	https://docs.python.org/dev/library/sqlite3.html#sqlite3-connection-context-manager
ResourceWarning	https://docs.python.org/dev/library/exceptions.html#ResourceWarning
close()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.close
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.cursor
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
callable	https://docs.python.org/dev/glossary.html#term-callable
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.blobopen
Blob	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob
str	https://docs.python.org/dev/library/stdtypes.html#str
str	https://docs.python.org/dev/library/stdtypes.html#str
int	https://docs.python.org/dev/library/functions.html#int
bool	https://docs.python.org/dev/library/functions.html#bool
str	https://docs.python.org/dev/library/stdtypes.html#str
OperationalError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.OperationalError
Blob	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob
Blob	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.commit
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.rollback
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.close
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
commit()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.commit
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.execute
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.executemany
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
executemany()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executemany
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.executescript
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
executescript()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executescript
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.create_function
str	https://docs.python.org/dev/library/stdtypes.html#str
int	https://docs.python.org/dev/library/functions.html#int
callback	https://docs.python.org/dev/glossary.html#term-callback
callable	https://docs.python.org/dev/glossary.html#term-callable
a type natively supported by SQLite	https://docs.python.org/dev/library/sqlite3.html#sqlite3-types
bool	https://docs.python.org/dev/library/functions.html#bool
deterministic	https://sqlite.org/deterministic.html
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.create_aggregate
str	https://docs.python.org/dev/library/stdtypes.html#str
int	https://docs.python.org/dev/library/functions.html#int
class	https://docs.python.org/dev/glossary.html#term-class
a type natively supported by SQLite	https://docs.python.org/dev/library/sqlite3.html#sqlite3-types
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.create_window_function
str	https://docs.python.org/dev/library/stdtypes.html#str
int	https://docs.python.org/dev/library/functions.html#int
class	https://docs.python.org/dev/glossary.html#term-class
a type natively supported by SQLite	https://docs.python.org/dev/library/sqlite3.html#sqlite3-types
NotSupportedError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.NotSupportedError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.create_collation
string	https://docs.python.org/dev/library/stdtypes.html#str
integer	https://docs.python.org/dev/library/functions.html#int
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.interrupt
OperationalError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.OperationalError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.set_authorizer
callable	https://docs.python.org/dev/glossary.html#term-callable
SQLITE_OK	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_OK
SQLITE_DENY	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_DENY
SQLITE_IGNORE	https://docs.python.org/dev/library/sqlite3.html#sqlite3.SQLITE_IGNORE
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.set_progress_handler
callable	https://docs.python.org/dev/glossary.html#term-callable
DatabaseError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DatabaseError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.set_trace_callback
callable	https://docs.python.org/dev/glossary.html#term-callable
str	https://docs.python.org/dev/library/stdtypes.html#str
Cursor.execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
transaction management	https://docs.python.org/dev/library/sqlite3.html#sqlite3-controlling-transactions
enable_callback_tracebacks()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.enable_callback_tracebacks
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.enable_load_extension
--enable-loadable-sqlite-extensions	https://docs.python.org/dev/using/configure.html#cmdoption-enable-loadable-sqlite-extensions
auditing event	https://docs.python.org/dev/library/sys.html#auditing
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.load_extension
enable_load_extension()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.enable_load_extension
str	https://docs.python.org/dev/library/stdtypes.html#str
str	https://docs.python.org/dev/library/stdtypes.html#str
Loading an Extension	https://www.sqlite.org/loadext.html#loading_an_extension
auditing event	https://docs.python.org/dev/library/sys.html#auditing
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.iterdump
iterator	https://docs.python.org/dev/glossary.html#term-iterator
str	https://docs.python.org/dev/library/stdtypes.html#str
How to handle non-UTF-8 text encodings	https://docs.python.org/dev/library/sqlite3.html#sqlite3-howto-encoding
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.backup
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
int	https://docs.python.org/dev/library/functions.html#int
callback	https://docs.python.org/dev/glossary.html#term-callback
callable	https://docs.python.org/dev/glossary.html#term-callable
str	https://docs.python.org/dev/library/stdtypes.html#str
float	https://docs.python.org/dev/library/functions.html#float
How to handle non-UTF-8 text encodings	https://docs.python.org/dev/library/sqlite3.html#sqlite3-howto-encoding
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.getlimit
int	https://docs.python.org/dev/library/functions.html#int
SQLite limit category	https://www.sqlite.org/c3ref/c_limit_attached.html
int	https://docs.python.org/dev/library/functions.html#int
ProgrammingError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.setlimit
int	https://docs.python.org/dev/library/functions.html#int
SQLite limit category	https://www.sqlite.org/c3ref/c_limit_attached.html
int	https://docs.python.org/dev/library/functions.html#int
int	https://docs.python.org/dev/library/functions.html#int
ProgrammingError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.getconfig
int	https://docs.python.org/dev/library/functions.html#int
SQLITE_DBCONFIG code	https://docs.python.org/dev/library/sqlite3.html#sqlite3-dbconfig-constants
bool	https://docs.python.org/dev/library/functions.html#bool
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.setconfig
int	https://docs.python.org/dev/library/functions.html#int
SQLITE_DBCONFIG code	https://docs.python.org/dev/library/sqlite3.html#sqlite3-dbconfig-constants
bool	https://docs.python.org/dev/library/functions.html#bool
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.serialize
bytes	https://docs.python.org/dev/library/stdtypes.html#bytes
str	https://docs.python.org/dev/library/stdtypes.html#str
bytes	https://docs.python.org/dev/library/stdtypes.html#bytes
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.deserialize
serialized	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.serialize
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
bytes	https://docs.python.org/dev/library/stdtypes.html#bytes
str	https://docs.python.org/dev/library/stdtypes.html#str
OperationalError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.OperationalError
DatabaseError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DatabaseError
OverflowError	https://docs.python.org/dev/library/exceptions.html#OverflowError
len(data)	https://docs.python.org/dev/library/functions.html#len
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
PEP 249	https://peps.python.org/pep-0249/
PEP 249	https://peps.python.org/pep-0249/
commit()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.commit
rollback()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.rollback
autocommit mode	https://www.sqlite.org/lang_transaction.html#implicit_versus_explicit_transactions
commit()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.commit
rollback()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.rollback
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
PEP 249	https://peps.python.org/pep-0249/
isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
Transaction control via the autocommit attribute	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-autocommit
isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.in_transaction
autocommit mode	https://www.sqlite.org/lang_transaction.html#implicit_versus_explicit_transactions
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
legacy transaction handling mode	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-isolation-level
SQLite transaction behaviour	https://www.sqlite.org/lang_transaction.html#deferred_immediate_and_exclusive_transactions
implicit transaction management	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-isolation-level
connect()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.row_factory
row_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.row_factory
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
tuple	https://docs.python.org/dev/library/stdtypes.html#tuple
How to create and use row factories	https://docs.python.org/dev/library/sqlite3.html#sqlite3-howto-row-factory
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.text_factory
callable	https://docs.python.org/dev/glossary.html#term-callable
bytes	https://docs.python.org/dev/library/stdtypes.html#bytes
str	https://docs.python.org/dev/library/stdtypes.html#str
How to handle non-UTF-8 text encodings	https://docs.python.org/dev/library/sqlite3.html#sqlite3-howto-encoding
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.total_changes
¶	https://docs.python.org/dev/library/sqlite3.html#cursor-objects
database cursor	https://en.wikipedia.org/wiki/Cursor_(databases)
Connection.cursor()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.cursor
connection shortcut methods	https://docs.python.org/dev/library/sqlite3.html#sqlite3-connection-shortcuts
iterators	https://docs.python.org/dev/glossary.html#term-iterator
execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
placeholders	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
str	https://docs.python.org/dev/library/stdtypes.html#str
dict	https://docs.python.org/dev/library/stdtypes.html#dict
sequence	https://docs.python.org/dev/glossary.html#term-sequence
How to use placeholders to bind values in SQL queries	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
ProgrammingError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
named placeholders	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
dict	https://docs.python.org/dev/library/stdtypes.html#dict
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
ProgrammingError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
named placeholders	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
dict	https://docs.python.org/dev/library/stdtypes.html#dict
executescript()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executescript
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executemany
parameterized	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
str	https://docs.python.org/dev/library/stdtypes.html#str
iterable	https://docs.python.org/dev/glossary.html#term-iterable
How to use placeholders to bind values in SQL queries	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
ProgrammingError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
named placeholders	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
dict	https://docs.python.org/dev/library/stdtypes.html#dict
RETURNING clauses	https://www.sqlite.org/lang_returning.html
ProgrammingError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
named placeholders	https://docs.python.org/dev/library/sqlite3.html#sqlite3-placeholders
dict	https://docs.python.org/dev/library/stdtypes.html#dict
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executescript
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
string	https://docs.python.org/dev/library/stdtypes.html#str
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.fetchone
row_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.row_factory
tuple	https://docs.python.org/dev/library/stdtypes.html#tuple
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.fetchmany
list	https://docs.python.org/dev/library/stdtypes.html#list
arraysize	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.arraysize
fetchmany()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.fetchmany
ValueError	https://docs.python.org/dev/library/exceptions.html#ValueError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.fetchall
list	https://docs.python.org/dev/library/stdtypes.html#list
arraysize	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.arraysize
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.close
ProgrammingError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.setinputsizes
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.setoutputsize
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.arraysize
fetchmany()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.fetchmany
ValueError	https://docs.python.org/dev/library/exceptions.html#ValueError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.connection
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
con.cursor()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.cursor
connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.connection
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.description
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.lastrowid
execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
executemany()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executemany
executescript()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executescript
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.rowcount
execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
executemany()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executemany
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.row_factory
tuple	https://docs.python.org/dev/library/stdtypes.html#tuple
sqlite3.Row	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Row
callable	https://docs.python.org/dev/glossary.html#term-callable
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
Connection.row_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.row_factory
Connection.row_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.row_factory
How to create and use row factories	https://docs.python.org/dev/library/sqlite3.html#sqlite3-howto-row-factory
¶	https://docs.python.org/dev/library/sqlite3.html#row-objects
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Row
row_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.row_factory
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
len()	https://docs.python.org/dev/library/functions.html#len
mapping	https://docs.python.org/dev/glossary.html#term-mapping
How to create and use row factories	https://docs.python.org/dev/library/sqlite3.html#sqlite3-howto-row-factory
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Row.keys
list	https://docs.python.org/dev/library/stdtypes.html#list
strings	https://docs.python.org/dev/library/stdtypes.html#str
Cursor.description	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.description
¶	https://docs.python.org/dev/library/sqlite3.html#blob-objects
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob
Blob	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob
file-like object	https://docs.python.org/dev/glossary.html#term-file-like-object
len(blob)	https://docs.python.org/dev/library/functions.html#len
slices	https://docs.python.org/dev/glossary.html#term-slice
Blob	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob
context manager	https://docs.python.org/dev/glossary.html#term-context-manager
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob.close
Error	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Error
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob.read
read()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob.read
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob.write
ValueError	https://docs.python.org/dev/library/exceptions.html#ValueError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob.tell
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Blob.seek
os.SEEK_SET	https://docs.python.org/dev/library/os.html#os.SEEK_SET
os.SEEK_CUR	https://docs.python.org/dev/library/os.html#os.SEEK_CUR
os.SEEK_END	https://docs.python.org/dev/library/os.html#os.SEEK_END
¶	https://docs.python.org/dev/library/sqlite3.html#prepareprotocol-objects
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PrepareProtocol
PEP 246	https://peps.python.org/pep-0246/
adapt themselves	https://docs.python.org/dev/library/sqlite3.html#sqlite3-conform
native SQLite types	https://docs.python.org/dev/library/sqlite3.html#sqlite3-types
¶	https://docs.python.org/dev/library/sqlite3.html#exceptions
PEP 249	https://peps.python.org/pep-0249/
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Warning
Exception	https://docs.python.org/dev/library/exceptions.html#Exception
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Error
except	https://docs.python.org/dev/reference/compound_stmts.html#except
Exception	https://docs.python.org/dev/library/exceptions.html#Exception
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Error.sqlite_errorcode
SQLite API	https://sqlite.org/rescode.html
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Error.sqlite_errorname
SQLite API	https://sqlite.org/rescode.html
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.InterfaceError
Error	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Error
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DatabaseError
Error	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Error
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DataError
DatabaseError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DatabaseError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.OperationalError
DatabaseError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DatabaseError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.IntegrityError
DatabaseError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DatabaseError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.InternalError
DatabaseError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DatabaseError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
DatabaseError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DatabaseError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite3.NotSupportedError
create_function()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.create_function
DatabaseError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.DatabaseError
¶	https://docs.python.org/dev/library/sqlite3.html#sqlite-and-python-types
int	https://docs.python.org/dev/library/functions.html#int
float	https://docs.python.org/dev/library/functions.html#float
str	https://docs.python.org/dev/library/stdtypes.html#str
bytes	https://docs.python.org/dev/library/stdtypes.html#bytes
int	https://docs.python.org/dev/library/functions.html#int
float	https://docs.python.org/dev/library/functions.html#float
text_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.text_factory
str	https://docs.python.org/dev/library/stdtypes.html#str
bytes	https://docs.python.org/dev/library/stdtypes.html#bytes
object adapters	https://docs.python.org/dev/library/sqlite3.html#sqlite3-adapters
converters	https://docs.python.org/dev/library/sqlite3.html#sqlite3-converters
¶	https://docs.python.org/dev/library/sqlite3.html#default-adapters-and-converters-deprecated
Adapter and converter recipes	https://docs.python.org/dev/library/sqlite3.html#sqlite3-adapter-converter-recipes
datetime.date	https://docs.python.org/dev/library/datetime.html#datetime.date
strings	https://docs.python.org/dev/library/stdtypes.html#str
ISO 8601	https://en.wikipedia.org/wiki/ISO_8601
datetime.datetime	https://docs.python.org/dev/library/datetime.html#datetime.datetime
declared	https://docs.python.org/dev/library/sqlite3.html#sqlite3-converters
datetime.date	https://docs.python.org/dev/library/datetime.html#datetime.date
datetime.datetime	https://docs.python.org/dev/library/datetime.html#datetime.datetime
datetime.datetime	https://docs.python.org/dev/library/datetime.html#datetime.datetime
register_converter()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.register_converter
¶	https://docs.python.org/dev/library/sqlite3.html#command-line-interface
-m	https://docs.python.org/dev/using/cmdline.html#cmdoption-m
¶	https://docs.python.org/dev/library/sqlite3.html#cmdoption-python-m-sqlite3-h-v-filename-sql-h
¶	https://docs.python.org/dev/library/sqlite3.html#cmdoption-python-m-sqlite3-h-v-filename-sql-v
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-guides
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-use-placeholders-to-bind-values-in-sql-queries
SQL injection attacks	https://en.wikipedia.org/wiki/SQL_injection
tuple	https://docs.python.org/dev/library/stdtypes.html#tuple
execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
sequence	https://docs.python.org/dev/glossary.html#term-sequence
ProgrammingError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.ProgrammingError
dict	https://docs.python.org/dev/library/stdtypes.html#dict
PEP 249	https://peps.python.org/pep-0249/
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-adapt-custom-python-types-to-sqlite-values
Python types SQLite natively understands	https://docs.python.org/dev/library/sqlite3.html#sqlite3-types
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-write-adaptable-objects
PrepareProtocol	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PrepareProtocol
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-register-adapter-callables
register_adapter()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.register_adapter
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-convert-sqlite-values-to-custom-python-types
bytes	https://docs.python.org/dev/library/stdtypes.html#bytes
connect()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
PARSE_DECLTYPES	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PARSE_DECLTYPES
PARSE_COLNAMES	https://docs.python.org/dev/library/sqlite3.html#sqlite3.PARSE_COLNAMES
¶	https://docs.python.org/dev/library/sqlite3.html#adapter-and-converter-recipes
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-use-connection-shortcut-methods
execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.execute
executemany()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.executemany
executescript()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.executescript
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-use-the-connection-context-manager
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
with	https://docs.python.org/dev/reference/compound_stmts.html#with
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
contextlib.closing()	https://docs.python.org/dev/library/contextlib.html#contextlib.closing
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-work-with-sqlite-uris
OperationalError	https://docs.python.org/dev/library/sqlite3.html#sqlite3.OperationalError
SQLite URI documentation	https://www.sqlite.org/uri.html
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-create-and-use-row-factories
tuple	https://docs.python.org/dev/library/stdtypes.html#tuple
sqlite3.Row	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Row
row_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.row_factory
Cursor	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
Connection.row_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.row_factory
row_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.row_factory
dict	https://docs.python.org/dev/library/stdtypes.html#dict
named tuple	https://docs.python.org/dev/glossary.html#term-named-tuple
dataclass	https://docs.python.org/dev/library/dataclasses.html#dataclasses.dataclass
namedtuple	https://docs.python.org/dev/library/collections.html#collections.namedtuple
¶	https://docs.python.org/dev/library/sqlite3.html#how-to-handle-non-utf-8-text-encodings
str	https://docs.python.org/dev/library/stdtypes.html#str
text_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.text_factory
flexible typing	https://www.sqlite.org/flextypegood.html
Connection	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection
text_factory	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.text_factory
Unicode HOWTO	https://docs.python.org/dev/howto/unicode.html#unicode-howto
Unicode HOWTO	https://docs.python.org/dev/howto/unicode.html#unicode-howto
¶	https://docs.python.org/dev/library/sqlite3.html#explanation
¶	https://docs.python.org/dev/library/sqlite3.html#transaction-control
Transaction control via the autocommit attribute	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-autocommit
Transaction control via the isolation_level attribute	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-isolation-level
¶	https://docs.python.org/dev/library/sqlite3.html#transaction-control-via-the-autocommit-attribute
Connection.autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
connect()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
PEP 249	https://peps.python.org/pep-0249/
connect()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.connect
Connection.commit()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.commit
Connection.rollback()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.rollback
close()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.close
autocommit mode	https://www.sqlite.org/lang_transaction.html#implicit_versus_explicit_transactions
Connection.commit()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.commit
Connection.rollback()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.rollback
PEP 249	https://peps.python.org/pep-0249/
Connection.autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
Connection.in_transaction	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.in_transaction
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
Connection.isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
Transaction control via the isolation_level attribute	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-isolation-level
¶	https://docs.python.org/dev/library/sqlite3.html#transaction-control-via-the-isolation-level-attribute
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
Transaction control via the autocommit attribute	https://docs.python.org/dev/library/sqlite3.html#sqlite3-transaction-control-autocommit
Connection.autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROL	https://docs.python.org/dev/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
Connection.isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
execute()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.execute
executemany()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executemany
commit()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.commit
rollback()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.rollback
SQLite transaction behaviour	https://www.sqlite.org/lang_transaction.html#deferred_immediate_and_exclusive_transactions
isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
autocommit mode	https://www.sqlite.org/lang_transaction.html#implicit_versus_explicit_transactions
in_transaction	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.in_transaction
executescript()	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Cursor.executescript
isolation_level	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.isolation_level
autocommit	https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.autocommit
Table of Contents	https://docs.python.org/dev/contents.html
sqlite3 — DB-API 2.0 interface for SQLite databases	https://docs.python.org/dev/library/sqlite3.html
Tutorial	https://docs.python.org/dev/library/sqlite3.html#tutorial
Reference	https://docs.python.org/dev/library/sqlite3.html#reference
Module functions	https://docs.python.org/dev/library/sqlite3.html#module-functions
Module constants	https://docs.python.org/dev/library/sqlite3.html#module-constants
Connection objects	https://docs.python.org/dev/library/sqlite3.html#connection-objects
Cursor objects	https://docs.python.org/dev/library/sqlite3.html#cursor-objects
Row objects	https://docs.python.org/dev/library/sqlite3.html#row-objects
Blob objects	https://docs.python.org/dev/library/sqlite3.html#blob-objects
PrepareProtocol objects	https://docs.python.org/dev/library/sqlite3.html#prepareprotocol-objects
Exceptions	https://docs.python.org/dev/library/sqlite3.html#exceptions
SQLite and Python types	https://docs.python.org/dev/library/sqlite3.html#sqlite-and-python-types
Default adapters and converters (deprecated)	https://docs.python.org/dev/library/sqlite3.html#default-adapters-and-converters-deprecated
Command-line interface	https://docs.python.org/dev/library/sqlite3.html#command-line-interface
How-to guides	https://docs.python.org/dev/library/sqlite3.html#how-to-guides
How to use placeholders to bind values in SQL queries	https://docs.python.org/dev/library/sqlite3.html#how-to-use-placeholders-to-bind-values-in-sql-queries
How to adapt custom Python types to SQLite values	https://docs.python.org/dev/library/sqlite3.html#how-to-adapt-custom-python-types-to-sqlite-values
How to write adaptable objects	https://docs.python.org/dev/library/sqlite3.html#how-to-write-adaptable-objects
How to register adapter callables	https://docs.python.org/dev/library/sqlite3.html#how-to-register-adapter-callables
How to convert SQLite values to custom Python types	https://docs.python.org/dev/library/sqlite3.html#how-to-convert-sqlite-values-to-custom-python-types
Adapter and converter recipes	https://docs.python.org/dev/library/sqlite3.html#adapter-and-converter-recipes
How to use connection shortcut methods	https://docs.python.org/dev/library/sqlite3.html#how-to-use-connection-shortcut-methods
How to use the connection context manager	https://docs.python.org/dev/library/sqlite3.html#how-to-use-the-connection-context-manager
How to work with SQLite URIs	https://docs.python.org/dev/library/sqlite3.html#how-to-work-with-sqlite-uris
How to create and use row factories	https://docs.python.org/dev/library/sqlite3.html#how-to-create-and-use-row-factories
How to handle non-UTF-8 text encodings	https://docs.python.org/dev/library/sqlite3.html#how-to-handle-non-utf-8-text-encodings
Explanation	https://docs.python.org/dev/library/sqlite3.html#explanation
Transaction control	https://docs.python.org/dev/library/sqlite3.html#transaction-control
Transaction control via the autocommit attribute	https://docs.python.org/dev/library/sqlite3.html#transaction-control-via-the-autocommit-attribute
Transaction control via the isolation_level attribute	https://docs.python.org/dev/library/sqlite3.html#transaction-control-via-the-isolation-level-attribute
dbm — Interfaces to Unix “databases”	https://docs.python.org/dev/library/dbm.html
Data Compression and Archiving	https://docs.python.org/dev/library/archiving.html
Report a bug	https://docs.python.org/dev/bugs.html
Show source	https://github.com/python/cpython/blob/main/Doc/library/sqlite3.rst?plain=1
index	https://docs.python.org/dev/genindex.html
modules	https://docs.python.org/dev/py-modindex.html
next	https://docs.python.org/dev/library/archiving.html
previous	https://docs.python.org/dev/library/dbm.html
Python	https://www.python.org/
3.15.0a5 Documentation	https://docs.python.org/dev/index.html
The Python Standard Library	https://docs.python.org/dev/library/index.html
Data Persistence	https://docs.python.org/dev/library/persistence.html
sqlite3 — DB-API 2.0 interface for SQLite databases	https://docs.python.org/dev/library/sqlite3.html
Copyright	https://docs.python.org/dev/copyright.html
History and License	https://docs.python.org/license.html
Please donate.	https://www.python.org/psf/donations/
Found a bug	https://docs.python.org/bugs.html
Sphinx	https://www.sphinx-doc.org/

Viewport: width=device-width, initial-scale=1.0

URLs of crawlers that visited me.