Apsw

========

The shell :ref:`dump <shell-cmd-dump>` command outputs the
`application_id
<https://www.sqlite.org/pragma.html#pragma_application_id>`__ in
addition to the `user_version
<https://www.sqlite.org/pragma.html#pragma_user_version>`__.

`PyPI <https://pypi.org/project/apsw/>`__ binary builds for `Python

========

:func:`apsw.ext.query_info` provides the count and names of bindings
parameters. (:issue:`528`)

Address how errors are handled in VFS xRandomness routine, that is
only called once by SQLite to seed its random number generator.
(:issue:`526`)

Added :meth:`Connection.vfsname` and updated corresponding shell
command to get the diagnostic names of the vfs stack for the
connection. (:issue:`525`)

Do not cache :meth:`Connection.pragma` statements to avoid encryption
keys, or pragmas that run during prepare from being retained.
(:issue:`522`)

:meth:`Connection.pragma` adds keyword ``schema`` argument to run
pragma against attached databases. (:issue:`524`)

========

Adjusted `levels
<https://docs.python.org/3/library/logging.html#levels>`__ in
:func:`apsw.ext.log_sqlite` to be lower for some SQLite messages like
`SQLITE_SCHEMA` and `SQLITE_NOTICE_RECOVER_WAL` (:issue:`518`)

Previous source releases were signed with `PGP
<https://en.wikipedia.org/wiki/Pretty_Good_Privacy>`__. Starting with
this release `Sigstore's <https://www.sigstore.dev/>`__ `cosign tool
<https://docs.sigstore.dev/cosign/>`__ is used. (:issue:`512`)

========

No APSW changes.

========

Minor doc and tests change due to changed behaviour of
`sqlite3_serialize <https://sqlite.org/c3ref/serialize.html>`__ on an
empty database, used by :meth:`Connection.serialize`.

========

No APSW changes.