APSW 3.40.1.0 Released

[Roger Binns]

APSW 3.40.1.0 is now available. The project is at https://github.com/rogerbinns/apsw which includes full documentation, downloads, 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

Implemented window functions (APSW issue 292)

Function flags can be specified to Connection.createscalarfunction() and Connection.createaggregatefunction(). Added apsw.mapping_function_flags. (APSW issue 384)

Added Connection.trace_v2() with apsw.mapping_trace_codes and apsw.mapping_statement_status (APSW issue 383)

Ensure all SQLite APIs are wrapped. Connection.system_errno, apsw.strlike(), apsw.strglob(), apsw.stricmp(), apsw.strnicmp(), Connection.filename_wal, Connection.filename_journal, Connection.table_exists(), Connection.column_metadata(), Error.error_offset, Connection.cacheflush(), Connection.release_memory(), apsw.hard_heap_limit(). Connection.drop_modules() (APSW issue 382)

When an unraisable exception happens, sqlite3_log is now called so you will have context within SQLite’s actions. sys.unraisablehook is now called first, and if it doesn’t exist then sys.excepthook as before. (APSW issue 385)

When the wrong type is given for a function argument, the error message now includes the parameter name and function signature. (APSW issue 358)

Let SQLite do size checking instead of APSW for strings and blobs. (APSW issue 387)

Added apsw.ext.log_sqlite() which installs a handler that forwards SQLite messages to the logging module.

Added set_default_vfs() and unregister_vfs() taking vfs names. The test suite also unregisters ZipVFS (APSW issue 394)

Roger