Dirk Mueller
9b633c6a33
* All objects that can be closed implement __bool__() which
returns True while open and False when closed - Connection,
Cursor, Backup, Blob, Session, ChangesetBuilder, Rebaser.
- update to 3.51.0.0:
* JSON can be used as though it is a native type of SQLite,
with automatic conversion of Python objects on writing and
reading. (example)
* Connection.convert_binding (and Cursor.convert_binding)
callback to allow conversion of bindings when executing SQL.
* Connection.convert_jsonb (and Cursor.convert_jsonb) callback
to allow conversion of JSONB when reading query results.
(JSONB is SQLite’s binary internal parsed format for quick
operations on JSON.)
* 3 functions for working directly with JSONB allowing direct
conversion between Python objects and JSONB, without having
to go through the intermediate JSON text format.
* Added apsw.ext.Function() for calling SQL functions directly
from Python.
* When using with (Connection context manager) you can set the
outer transaction mode to DEFERRED (default) / IMMEDIATE /
EXCLUSIVE. (APSW issue 578)
* Changeset.apply() now takes filter_change parameter for
allowing filtering on individual change level, taking
advantage of sqlite3changeset_apply_v3
* Updated Connection.status() to use 64 bit API, and
apsw.ext.ShowResourceUsage() to show TEMPBUF_SPILL. (pragma
cache_size controls the amount of temp/cache memory
available.)
* The percentile extension is enabled when enabling all
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-apsw?expand=0&rev=63
2.9 KiB
2.9 KiB