APSW documentation ================== .. centered:: APSW |version| released |today| 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 :ref:`not compliant ` with that API because instead it works the way SQLite 3 does. (Read more about the :ref:`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 :ref:`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 :doc:`downloaded ` from `PyPI `__ * :ref:`genindex` * :ref:`search` .. toctree:: :maxdepth: 2 tips example download build extensions apsw connection cursor blob backup vtable vfs shell ext exceptions types execution dbapi pysqlite benchmarking copyright changes