APSW 3.51.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
All objects that can be closed implement __bool__() which returns True while open and False when closed - Connection, Cursor, Backup, Blob, Session, ChangesetBuilder, Rebaser.
Roger