apsw: Another Python SQLite Wrapper

APSW (Another Python SQLite Wrapper) is a lightweight CPython extension that exposes the complete SQLite C API to Python, targeting CPython 3.10 and later. It provides low-level access to SQLite features often missing or simplified by the standard library sqlite3 module: full-text search, session handling, virtual tables, custom virtual file systems (VFS), JSON support, CArray interfaces, and more. All SQLite functionality is available both synchronously and with full support for async frameworks, and the project explicitly positions itself for developers who need complete SQLite capabilities and a closer mapping to the underlying C APIs rather than interchangeability with other DB drivers.

The project is actively maintained and well-documented, with example code, a tour, and a differences section comparing APSW to sqlite3. Releases are published to PyPI and GitHub and the repository shows extensive history (thousands of commits), hundreds of stars and forks. Community support is via a Python SQLite discussion group, GitHub discussions, issue tracking for bugs, and direct contact with the author. Installation is via pip, licensing is OSI‑approved open source, and the documentation and examples make it practical to adopt when full SQLite feature access and developer control are required.