APSW stands for Another Python SQLite Wrapper. APSW supports CPython 3.10 onwards.
APSW lets you get the most out of the SQLite embedded relational database engine from Python, and the most out of Python from SQLite. APSW glues together the complete SQLite C API and Python's C API, staying up to date with both SQLite and Python. This includes full text search, session, virtual tables, VFS (virtual file system), JSON, and CArray. All functionality is available in regular synchronous code, as well as full support for all the async frameworks.
It is recommended to use the builtin sqlite3 module if you want SQLite to appear interchangeable with the other database drivers.
Use APSW when you want to use SQLite fully, and have an improved developer experience. The documentation has a section on the differences between APSW and sqlite3.
