● Covered by 1 source · 1 reportLow impact1 neutral
APSW: Another Python SQLite Wrapper Supports CPython 3.10+ with Full SQLite C API
Key points
- APSW supports CPython 3.10 and newer.
- It exposes the complete SQLite C API to Python.
- Includes features like full-text search, virtual tables, and VFS.
- Offers synchronous and asynchronous framework support.
APSW Overview
APSW, or Another Python SQLite Wrapper, provides a binding for the SQLite embedded relational database engine in Python. It is designed to offer full access to SQLite's capabilities from Python, and vice-versa, by gluing together the complete SQLite C API and Python's C API. This wrapper stays current with updates to both SQLite and Python.
Key Features and Capabilities
The wrapper includes support for advanced SQLite features such as full-text search, session management, virtual tables, Virtual File System (VFS), JSON functions, and CArray. All functionality is available for use in both regular synchronous code and various asynchronous frameworks. This comprehensive access differentiates APSW from Python's built-in `sqlite3` module.
Usage and Differentiation
While the built-in `sqlite3` module is recommended for basic SQLite usage where interchangeability with other database drivers is desired, APSW is intended for scenarios requiring full utilization of SQLite's features and an improved developer experience. Documentation is available that details the differences between APSW and `sqlite3`.
Availability and Support
APSW releases are distributed via PyPI and GitHub. Users can install it using `pip`. Support and discussions are primarily conducted through the Python SQLite discussion group and GitHub discussions. Bug reports can be submitted via the GitHub Issues page.
✨ This summary was generated by AI from the outlets' reporting listed below. It is not independently verified and may contain errors — check the original sources. How BrevFeed works →
The daily brief
One email each morning: the day's tech stories, clustered across outlets and summarized. No account needed.
One email a day. Unsubscribe in one click, any time.
Today's brief
Spend a few minutes, get the whole day. Every topic's top stories in one hands-free rundown — listen, watch, or read the transcript.
▶ Play today's brief
New every morning, and the back catalogue is archived by date.
Primary sources
GitHub cmc_internal/api GitHub github/collect GitHub rogerbinns/apsw GitHub _private/browser GitHub get-started/accessibility GitHub open-source/sponsorsReporting from
APSW, a Python SQLite wrapper, now supports CPython 3.10 and later versions, providing access to the complete SQLite C API. This allows Python developers to utilize advanced SQLite features like full-text search, virtual tables, and VFS, offering a more comprehensive integration than the built-in `sqlite3` module.