Apsw-sqlite3mc

========

Added :func:`apsw.ext.page_usage_to_svg` which shows database usage as
SVG (`example <_static/samples/chinook.svg>`__). Available as shell
:ref:`.pages-svg command <shell-cmd-pages-svg>`.

========

Documentation on how to :ref:`build for packagers <packagers>` such as
those maintaining Linux and BSD distributions.

Documentation on how to :ref:`build for pyodide <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 :doc:`shell
<shell>`. This also allows using `uvx apsw
<https://docs.astral.sh/uv/guides/tools/>`__ without having to
explicitly install APSW.

Added :func:`apsw.ext.analyze_pages` which uses `dbstat
<https://www.sqlite.org/dbstat.html>`__ to provide useful information
about the pages making up the database, and fragmentation. The shell
:ref:`.pages command <shell-cmd-pages>` shows it in a pretty form.

========

Support for Python 3.8 removed (:issue:`539`).

The readonly database statistics virtual table (`dbstat
<https://www.sqlite.org/dbstat.html>`__) is enabled by default for
PyPI builds, and when ``--enable-all-extensions`` is passed to manual
:ref:`builds <build>`.

Added :func:`recursive triggers
<apsw.bestpractice.connection_recursive_triggers>` and :func:`optimize
<apsw.bestpractice.connection_optimize>` to :mod:`apsw.bestpractice`.

Multiple callbacks can be present for :meth:`Connection.trace_v2` with
APSW ensuring they are all called (:issue:`502`)

:meth:`Connection.trace_v2` callback information now has ``trigger``,
``id``, and ``total_changes`` fields.

Added :attr:`Connection.data_version` for getting a change counter.
`pragma data_version
<https://sqlite.org/pragma.html#pragma_data_version>`__ doesn't update when
changes are made on the same connection, only others.

Added :func:`apsw.ext.ShowResourceUsage` for getting resource and
SQLite usage in a context block, and also use it for the shell
:ref:`timer <shell-cmd-timer>` command.

Added :func:`apsw.ext.Trace` for tracing SQL execution, row and change
counting, and timing per statement for use in a context block.

Added :doc:`FTS5 support <textsearch>` including registering and
calling tokenizers, and auxiliary functions. The :mod:`apsw.fts5`
module provides many additional classes and methods for working with
FTS5, including tokenizers for HTML, JSON, regular expressions,
support tokenizers for synonyms, stop words, transformers, and a
:class:`~apsw.fts5.Table` class that wraps access to a FTS5 table
(including :meth:`creating one <apsw.fts5.Table.create>`) with
:meth:`~apsw.fts5.Table.search`, :meth:`~apsw.fts5.Table.more_like`,
and :meth:`~apsw.fts5.Table.query_suggest`. :mod:`apsw.fts5query` can
parse, modify, and reconstruct queries. The shell gets a :ref:`ftsq
<shell-cmd-ftsq>` command for issuing queries.

Added :mod:`apsw.unicode` which implements Unicode algorithms for
determining codepoint groups making up a user perceived character,
word and sentence splitting, and where line breaks can be made. These
are used to make provided FTS5 tokenizers and auxiliary functions
fully Unicode aware. There are many additional methods such as
getting categories, stripping diacritics, case folding, width when
output to a terminal, text wrapping, and more.

:func:`apsw.ext.format_query_table` uses :mod:`apsw.unicode` to get
widths and line breaks more accurate. As a side effect it loses the
`word_wrap` parameter (breaking change).

========

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`)