APSW 3.47.1.0 Released

[Roger Binns]

APSW 3.47.1.0 is now available. The project is at https://github.com/rogerbinns/apsw which includes full documentation, source, installation information and more.

APSW is a wrapper around SQLite that provides all SQLite API functionality in Python. It is not DBAPI compliant as it provides SQLite semantics. sqlite3 provides DBAPI semantics. You can see the two approaches contrasted at https://rogerbinns.github.io/apsw/pysqlite.html

Changelist is below and at https://rogerbinns.github.io/apsw/changes.html

Documentation on how to build for packagers such as those maintaining Linux and BSD distributions.

Documentation on how to build for pyodide, the Python WASM implementation that runs in the browser and NPM. PyPI does not accept pyodide packages yet.

A command line tool apsw is defined which invokes the shell. This also allows using uvx apsw without having to explicitly install APSW.

Added apsw.ext.analyze_pages() which uses dbstat to provide useful information about the pages making up the database, and fragmentation. The shell .pages command shows it in a pretty form.

Roger