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.
There is a tour and example code using APSW at https://rogerbinns.github.io/apsw/example.html
The latest documentation is at https://rogerbinns.github.io/apsw/
- Python SQLite discussion group (preferred)
- Github discussions
- You can also email the author at [email protected]
Releases are made to PyPI (install using pip) and Github
New release announcements are sent to the Python SQLite discussion group and there is an RSS feed from PyPI.
You can find existing and fixed bugs by clicking on Issues and using "New Issue" to report previously unknown issues.
See LICENSE - in essence any OSI approved open source license.