APSW, or Another Python SQLite Wrapper, is a Python library that provides full access to the SQLite C API from Python. It supports CPython 3.10 onwards and enables developers to leverage the complete SQLite relational database engine. APSW combines the SQLite C API with Python's C API, offering support for advanced features like full-text search, sessions, virtual tables, VFS, JSON, and CArray. A key distinction is its comprehensive support for asynchronous frameworks, unlike the built-in sqlite3 module. While sqlite3 aims for interchangeability with other drivers, APSW is designed for users who need to use SQLite fully and want an improved developer experience. The project documentation includes a tour and example code, with the latest information available on the official website. Released via PyPI and GitHub, APSW is open source under an OSI-approved license. It is maintained through Python SQLite discussion groups and GitHub discussions, with the author contactable via email for support.
Key Features: Full SQLite C API access, async framework support, virtual tables, and JSON support.
Project Status: Actively developed with recent releases on PyPI and GitHub.
Community: Python SQLite discussion group and GitHub discussions as primary support channels.
Source: Hacker News · Summarized by HeadlinesBriefing