APSW documentation

APSW released 11 September 2022

Use with SQLite 3.39 or later, CPython 3.6 and later:

Version 3.37.0-r1 from January 2022 supports all CPython versions back to 2.3. The tips include more information about APSW and SQLite versions.

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. (Read more about 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 and can be downloaded from PyPI


Indices and tables