Apsw

========

Correctly handle NULL/None VFS filenames (:issue:`506`)

========

Added `logger` parameter to :func:`apsw.ext.log_sqlite` to use a
specific :class:`logging.Logger` (:issue:`493`)

Added :func:`apsw.ext.result_string` to turn an result code into
a string, taking into account if it is extended or not.

Provide detail when C implemented objects are printed. For example
:class:`connections <Connection>` include the filename.
(:issue:`494`)

Added :meth:`URIFilename.parameters` (:issue:`496`)

:class:`URIFilename` are only valid for the duration of the
:meth:`VFS.xOpen` call. If you save and use the object later you will
get an exception. (:issue:`501`)

========

Added virtual table :meth:`VTTable.Integrity` support.

On 64 bit platforms with the amalgamation, `SQLITE_MAX_MMAP_SIZE
<https://www.sqlite.org/mmap.html>`__ is set to 256 terabytes.
SQLite's default limit is 2GB. (:issue:`491`)

========

:meth:`Connection.create_aggregate_function` can take a class with step
and final methods. (:issue:`421`)

Corrected non :pep:`8` :ref:`compliant names <renaming>`. The old
names remain as aliases to the new ones, and your code will not break.

========

:doc:`Exception <exceptions>` handling has been updated, with multiple
exceptions in the same SQLite control flow being chained together.
Previously more would have used the :ref:`unraisable <unraisable>`
mechanism. (:issue:`489`)

Only use alloca with msvc because it doesn't support `VLA
<https://en.wikipedia.org/wiki/Variable-length_array>`__. The arrays
are used for fastcall. (:issue:`487`)

========

All C code calling into Python and all C code called by Python uses
vectorcall / fastcall (see :pep:`590`) which reduces the overhead of
passing and receiving positional and keyword arguments. (:issue:`477`,
:issue:`446`):

* Conversion of arguments from Python values to C values drops generic
:c:func:`PyArg_ParseTupleAndKeywords` in favour of direct processing
which is more efficient and allows better exception messages.

* Running :ref:`speedtest` with a VFS that inherits all methods went
from being 17% slower than pure SQLite to 2% slower.

* A :source:`virtual table benchmark <tools/vtbench.py>` takes 35%
less time. (Remember that benchmarks are best case!)

The :doc:`shell <shell>` JSON output modes have been fixed. Mode
'json' outputs a json array, while mode 'jsonl' does newline delimited
json objects, aka `json lines <https://jsonlines.org/>`__.
(:issue:`483`)