apsw: Another Python SQLite Wrapper
APSW is a Python wrapper for the SQLite database engine that provides full access to the SQLite C API. It is designed for developers who require advanced SQLite features and better performance than the standard library's sqlite3 module.
Why it matters
This tool is a critical resource for Python developers working with embedded databases who need deeper integration and functionality than default drivers provide.
APSW stands for A nother P ython S QLite W rapper. 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.
Get smarter about the news
Sign up free for a feed built around what you actually care about, Dive Deeper research on any story, and the full text of every article.
Create free accountAlready have an account? Sign in