APSW documentation

APSW 3.37.0-r1 released 4 January 2022

Use with SQLite 3.37 or later, CPython (2.3 and later, 3.1 and later).

This is the last release supporting Python 2 and Python 3 before 3.7. If you still use those Python versions then you should pin to this APSW version. (More information).

APSW provides an SQLite 3 wrapper that provides the thinnest layer over the SQLite database library possible. Everything you can do from the SQLite C API, you can do from Python. Although APSW looks vaguely similar to the PEP 249 (DBAPI), it is not compliant with that API because instead it works the way SQLite 3 does. (pysqlite which became the builtin sqlite3 module is DBAPI compliant - see the differences).

In general you should use Python’s builtin sqlite3 module. Use APSW when you are intentionally using SQLite, want to use its APIs, want to control what versions are used, or want to control SQLite’s configuration (primarily done at compile time) or extensions (like JSON or FTS)

APSW is hosted at https://github.com/rogerbinns/apsw


Indices and tables