605 lines
28 KiB
Plaintext
605 lines
28 KiB
Plaintext
|
|
-------------------------------------------------------------------
|
|||
|
|
Fri Dec 12 10:55:57 UTC 2025 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.51.1.0:
|
|||
|
|
* 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
|
|||
|
|
extensions, which is standard for pypi downloads. It enables
|
|||
|
|
several percentile, median, and related SQL functions.
|
|||
|
|
* The carray extension is enabled when enabling all extensions,
|
|||
|
|
which is standard for pypi downloads. apsw.carray() allows
|
|||
|
|
binding bulk numbers, strings, and blobs to a query. See the
|
|||
|
|
example.
|
|||
|
|
* SQLITE_SCM_ constants (BRANCH, TAGS, DATETIME) are available
|
|||
|
|
on the module if built with the amalgamation.
|
|||
|
|
* apsw.ext.generate_series_sqlite() updated to exactly match
|
|||
|
|
SQLite’s behaviour. apsw.ext.generate_series() is recommended
|
|||
|
|
as it matches other databases.
|
|||
|
|
* Updated apsw.unicode to support Unicode 17.0 which adds 4,803
|
|||
|
|
new codepoints, and updated line breaking, along with other
|
|||
|
|
small tweaks.
|
|||
|
|
* The Geopoly extension (GeoJSON access to RTree) is enabled
|
|||
|
|
when --enable-all-extensions is used with setup.py. This
|
|||
|
|
includes pypi builds.
|
|||
|
|
* This is the final release supporting Python 3.9.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Aug 5 08:38:22 UTC 2025 - John Paul Adrian Glaubitz <adrian.glaubitz@suse.com>
|
|||
|
|
|
|||
|
|
- Update to 3.50.4.0
|
|||
|
|
* PyPI binary builds are available for:
|
|||
|
|
* Python 3.14
|
|||
|
|
* Windows ARM
|
|||
|
|
* Python 3.14 `free threaded`__ (no GIL). The GIL will be
|
|||
|
|
enabled when APSW is loaded. APSW will be free threaded
|
|||
|
|
in the future (#568)
|
|||
|
|
- from version 3.50.3.0
|
|||
|
|
* preupdate_hook` is available. The `commit` and `rollback`
|
|||
|
|
hooks let you provide multiple callbacks, multiplex by APSW.
|
|||
|
|
`apsw.ext.Trace` can now show updates, and transaction begin,
|
|||
|
|
commit, and rollback.
|
|||
|
|
- from version 3.50.2.0
|
|||
|
|
* PyPi builds now use `cibuildwheel version 3` which advances
|
|||
|
|
the minimum supported Linux distribution. It is configured
|
|||
|
|
to continue building both 32 and 64 bit binaries.
|
|||
|
|
- from version 3.50.1.0
|
|||
|
|
* No user visible changes.
|
|||
|
|
- from version 3.50.0.0
|
|||
|
|
* Full support for the `session`
|
|||
|
|
* Added `Connection.setlk_timeout`, `apsw.mapping_setlk_timeout_flags`,
|
|||
|
|
and enabled the timeout for amalgamation builds such as PyPI.
|
|||
|
|
* Shell `open command <shell-cmd-open>` allows specifying flags to
|
|||
|
|
open a connection, and `connection command <shell-cmd-connection>`
|
|||
|
|
shows flags used for each open. (#557)
|
|||
|
|
* Type stubs updated to `collections.abc.Buffer` (Python 3.12+)
|
|||
|
|
wherever some bytes are taken. `Buffers `__ have always been used,
|
|||
|
|
but Python 3.12 added typing.
|
|||
|
|
- from version 3.49.2.0
|
|||
|
|
* Shell dump command handles generated columns correctly. (#556)
|
|||
|
|
- from version 3.49.1.0
|
|||
|
|
* No APSW changes.
|
|||
|
|
- from version 3.49.0.0
|
|||
|
|
* `Connection.set_progress_handler` allows multiple callbacks
|
|||
|
|
(multiplexed by APSW).
|
|||
|
|
* Added `apsw.ext.query_limit` to limit total row count and execution
|
|||
|
|
time within a block. (#520)
|
|||
|
|
* `Connection.config` updated with new DBCONFIG options
|
|||
|
|
* Adjustments for SQLite's new build process.
|
|||
|
|
- from version 3.48.0.0
|
|||
|
|
* You can `pass any Python objects <pyobject>` into SQLite, and
|
|||
|
|
return them when used as runtime values such as functions. SQLite's
|
|||
|
|
`pointer passing interface` is used behind the scenes. (#521)
|
|||
|
|
* `Source releases <sources>` are also available in tar format (#548),
|
|||
|
|
and have updated source release signing `instructions <verifydownload>`.
|
|||
|
|
(#549)
|
|||
|
|
* `Shared cache` (2006) is omitted when APSW includes the amalgamation
|
|||
|
|
like PyPI builds. This is `recommended by SQLite `, has been `discouraged
|
|||
|
|
for a long time`. `apsw.enable_shared_cache` will raise an exception
|
|||
|
|
if called and the shared cache has been omitted. You can see what options
|
|||
|
|
are in effect in `apsw.compile_options`. If you were using it for
|
|||
|
|
shared memory databases then `use the memdb VFS <memdb>`.
|
|||
|
|
- from version 3.47.2.0
|
|||
|
|
* Added `apsw.ext.page_usage_to_svg` which shows database usage as
|
|||
|
|
SVG. Available as shell `.pages-svg command <shell-cmd-pages-svg>`.
|
|||
|
|
- from version 3.47.1.0
|
|||
|
|
* Documentation on how to `build for packagers <packagers>` such as
|
|||
|
|
those maintaining Linux and BSD distributions.
|
|||
|
|
* Documentation on how to `build for 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 `shell
|
|||
|
|
<shell>`. This also allows using `uvx apsw` without having to
|
|||
|
|
explicitly install APSW.
|
|||
|
|
* Added `apsw.ext.analyze_pages` which uses `dbstat` to provide useful
|
|||
|
|
information about the pages making up the database, and fragmentation.
|
|||
|
|
The shell `.pages command <shell-cmd-pages>` shows it in a pretty form.
|
|||
|
|
- from version 3.47.0.0
|
|||
|
|
* Support for Python 3.8 removed (#539).
|
|||
|
|
* The readonly database statistics virtual table (`dbstat`) is enabled
|
|||
|
|
by default for PyPI builds, and when ``--enable-all-extensions`` is
|
|||
|
|
passed to manual `builds <build>`.
|
|||
|
|
* Added `recursive triggers <apsw.bestpractice.connection_recursive_triggers>`
|
|||
|
|
and `optimize <apsw.bestpractice.connection_optimize>` to `apsw.bestpractice`.
|
|||
|
|
* Multiple callbacks can be present for `Connection.trace_v2` with APSW ensuring
|
|||
|
|
they are all called (#502)
|
|||
|
|
* `Connection.trace_v2` callback information now has ``trigger``, ``id``,
|
|||
|
|
and ``total_changes`` fields.
|
|||
|
|
* Added `Connection.data_version` for getting a change counter. `pragma
|
|||
|
|
data_version` doesn't update when changes are made on the same connection,
|
|||
|
|
only others.
|
|||
|
|
* Added `apsw.ext.ShowResourceUsage` for getting resource and SQLite usage
|
|||
|
|
in a context block, and also use it for the shell `timer <shell-cmd-timer>`
|
|||
|
|
command.
|
|||
|
|
* Added `apsw.ext.Trace` for tracing SQL execution, row and change
|
|||
|
|
counting, and timing per statement for use in a context block.
|
|||
|
|
* Added `FTS5 support <textsearch>` including registering and
|
|||
|
|
calling tokenizers, and auxiliary functions. The `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
|
|||
|
|
`~apsw.fts5.Table` class that wraps access to a FTS5 table
|
|||
|
|
(including `creating one <apsw.fts5.Table.create>`) with
|
|||
|
|
`~apsw.fts5.Table.search`, `~apsw.fts5.Table.more_like`,
|
|||
|
|
and `~apsw.fts5.Table.query_suggest`. `apsw.fts5query` can
|
|||
|
|
parse, modify, and reconstruct queries. The shell gets a `ftsq
|
|||
|
|
<shell-cmd-ftsq>` command for issuing queries.
|
|||
|
|
* Added `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.
|
|||
|
|
* `apsw.ext.format_query_table` uses `apsw.unicode` to get widths and
|
|||
|
|
line breaks more accurate. As a side effect it loses the `word_wrap`
|
|||
|
|
parameter (breaking change).
|
|||
|
|
- Add support for both update-alternatives and libalternatives
|
|||
|
|
- Include apsw binary in %files section
|
|||
|
|
- Remove shebang from all Python sources
|
|||
|
|
- Switch upstream source back to PyPi
|
|||
|
|
- Update BuildRequires from pyproject.toml
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Sat Sep 28 19:15:48 UTC 2024 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.46.1.0:
|
|||
|
|
* The shell dump command outputs the application_id in addition
|
|||
|
|
to the user_version.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Sun Jun 30 21:32:30 UTC 2024 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.46.0.1:
|
|||
|
|
* :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`)
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Thu Jun 6 08:35:40 UTC 2024 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.46.0.0:
|
|||
|
|
* Adjusted 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. Starting with
|
|||
|
|
this release Sigstore's cosign tool is used
|
|||
|
|
(:ref:`instructions <verifydownload>`). (:issue:`512`)
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Sat Apr 20 14:09:15 UTC 2024 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.45.3.0:
|
|||
|
|
* No APSW changes.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Mon Mar 18 10:27:56 UTC 2024 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.45.2.0:
|
|||
|
|
* Minor doc and tests change due to changed behaviour of
|
|||
|
|
sqlite3_serialize on an empty database, used by
|
|||
|
|
:meth:`Connection.serialize`.
|
|||
|
|
* No APSW changes.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Sat Jan 20 12:28:34 UTC 2024 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.45.0.0:
|
|||
|
|
* Correctly handle NULL/None VFS filenames (:issue:`506`)
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Wed Jan 3 09:42:09 UTC 2024 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- require setuptools
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Sat Dec 2 20:18:36 UTC 2023 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.44.2.0:
|
|||
|
|
* 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.
|
|||
|
|
* 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`)
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Nov 14 15:52:45 UTC 2023 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.44.0.0:
|
|||
|
|
* Added virtual table :meth:`VTTable.Integrity` support.
|
|||
|
|
* On 64 bit platforms with the amalgamation,
|
|||
|
|
`SQLITE_MAX_MMAP_SIZE SQLite's default limit is 2GB.
|
|||
|
|
* :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.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Fri Oct 6 06:51:24 UTC 2023 - ecsos <ecsos@opensuse.org>
|
|||
|
|
|
|||
|
|
- Update to 3.43.1.0
|
|||
|
|
- 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. (APSW issue 477 APSW issue 446):
|
|||
|
|
* Conversion of arguments from Python values to C values drops
|
|||
|
|
generic PyArg_ParseTupleAndKeywords in favour of direct
|
|||
|
|
processing which is more efficient and allows better
|
|||
|
|
exception messages.
|
|||
|
|
* Running speedtest with a VFS that inherits all methods went
|
|||
|
|
from being 17% slower than pure SQLite to 2% slower.
|
|||
|
|
* A virtual table benchmark takes 35% less time. (Remember that
|
|||
|
|
benchmarks are best case!)
|
|||
|
|
- The shell JSON output modes have been fixed. Mode 'json'
|
|||
|
|
outputs a json array, while mode 'jsonl' does newline delimited
|
|||
|
|
json objects, aka json lines. (APSW issue 483)
|
|||
|
|
- Changes from 3.43.1.0
|
|||
|
|
- This is the last version that supports Python 3.6 and
|
|||
|
|
Python 3.7 (both end of life). The policy as stated in the
|
|||
|
|
about page is that there will be one more APSW release after
|
|||
|
|
a Python version goes end of life supporting that Python
|
|||
|
|
version. (APSW issue 471)
|
|||
|
|
- Added best practice module (APSW issue 460)
|
|||
|
|
- apsw.ext.log_sqlite() outputs SQLite warnings at warning level.
|
|||
|
|
(APSW issue 472)
|
|||
|
|
- sqlite3_stmt_explain is wrapped available as a explain keyword
|
|||
|
|
parameter on execute/executemany methods. (APSW issue 474)
|
|||
|
|
- Added documentation and helper class for implementing custom
|
|||
|
|
pragmas in your own Virtual File System (VFS) (APSW issue 464)
|
|||
|
|
- Reduced overhead of the Column method when using
|
|||
|
|
apsw.ext.make_virtual_module() (APSW issue 465)
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Wed Jul 26 14:57:47 UTC 2023 - Matej Cepl <mcepl@suse.com>
|
|||
|
|
|
|||
|
|
- Update to 3.42.0.1:
|
|||
|
|
- Work with SQLite compiled with
|
|||
|
|
SQLITE_OMIT_DEPRECATED. Connection.setprofile() was changed
|
|||
|
|
from using the deprecated sqlite3_profile to sqlite3_trace_v2
|
|||
|
|
giving the same results. When including the amalgamation,
|
|||
|
|
SQLITE_OMIT_DEPRECATED is defined. (APSW issue 443)
|
|||
|
|
- Shell updates adding various commands to match the SQLite
|
|||
|
|
shell, as well as code and documentation improvements. (APSW
|
|||
|
|
issue 397)
|
|||
|
|
- Added Connection.read() and apsw.ext.dbinfo() to provide
|
|||
|
|
information from the database and journal/wal files. The
|
|||
|
|
shell command .dbinfo displays it.
|
|||
|
|
- Added apsw.vfs_details(). The shell command .vfslist displays
|
|||
|
|
it.
|
|||
|
|
- Implemented VFS method xCurrentTimeInt64. The default SQLite
|
|||
|
|
VFS no longer provide xCurrentTime (floating point version)
|
|||
|
|
if SQLITE_OMIT_DEPRECATED is defined, so this is needed for
|
|||
|
|
inheritance to work. (APSW issue 451)
|
|||
|
|
- Backwards incompatible change: VFS If you override
|
|||
|
|
xCurrentTime, then you will need to override
|
|||
|
|
xCurrentTimeInt64 in the same way, or exclude
|
|||
|
|
xCurrentTimeInt64 in VFS, or use iVersion of 1.
|
|||
|
|
- speedtest now shows summary statistics, and improved help
|
|||
|
|
text. (APSW issue 444)
|
|||
|
|
- Clean up the SPEC file, use %pyproject_* macros instead.
|
|||
|
|
- Make the test suite pass again (gh#rogerbinns/apsw#462).
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Jun 20 12:17:34 UTC 2023 - ecsos <ecsos@opensuse.org>
|
|||
|
|
|
|||
|
|
- Add %{?sle15_python_module_pythons}
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Sat May 27 21:01:59 UTC 2023 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.42.0.0:
|
|||
|
|
* Shell: Errors when SQLite are preparing a statement now show
|
|||
|
|
the relevant extract of the query, and where the error was
|
|||
|
|
detected.
|
|||
|
|
* Shell: Output modes table (ASCII line drawing, lots of
|
|||
|
|
sanitization), box (Unicode line drawing) and
|
|||
|
|
qbox (box with quoted values) available.
|
|||
|
|
* Shell: if started interactively then box is the default mode
|
|||
|
|
(list remains the default in non-interactive)
|
|||
|
|
* Added :meth:`Connection.pragma` to execute pragmas
|
|||
|
|
and get results.
|
|||
|
|
* Added :attr:`Cursor.get` returning query results with the
|
|||
|
|
least amount of structure.
|
|||
|
|
* Fixed execution tracers should return comment text for
|
|||
|
|
comment only queries, and add :attr:`Cursor.has_vdbe`.
|
|||
|
|
* Ensure that all applicable options are implemented for
|
|||
|
|
:func:`apsw.config`, :meth:`Connection.config` and similar.
|
|||
|
|
* Added :func:`apsw.sleep`
|
|||
|
|
* Strings for :meth:`apsw.VFS.xNextSystemCall` are interned
|
|||
|
|
* Detect unbound recursion not handled by CPython, and handle
|
|||
|
|
better.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Sun Apr 16 09:22:57 UTC 2023 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.41.2.0:
|
|||
|
|
* Fixed :issue:`412` in :meth:`apsw.ext.make_virtual_module`.
|
|||
|
|
* Added :meth:`apsw.connections` to get all connections.
|
|||
|
|
* :func:`sys.unraisablehook` is called correctly (:issue:`410`)
|
|||
|
|
* Be stricter where :class:`bool` values are expected (eg
|
|||
|
|
* :meth:`VTTable.BestIndex`), only accepting :class:`int` and
|
|||
|
|
:class:`bool`. Previously you could for example supply
|
|||
|
|
strings and lists, which were almost certainly unintended
|
|||
|
|
errors.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Fri Feb 10 10:08:26 UTC 2023 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.40.1.0:
|
|||
|
|
* Implemented `window functions
|
|||
|
|
* Function flags can be specified to
|
|||
|
|
Connection.createscalarfunction and
|
|||
|
|
Connection.createaggregatefunction
|
|||
|
|
* Added apsw.mapping_function_flags
|
|||
|
|
* Added Connection.trace_v2` with apsw.mapping_trace_codes
|
|||
|
|
and apsw.mapping_statement_status
|
|||
|
|
* Ensure all SQLite APIs are wrapped.
|
|||
|
|
* When an unraisable exception happens, sqlite3_log is
|
|||
|
|
now called so you will have context within SQLite's actions.
|
|||
|
|
* sys.unraisablehook now called first, and if it doesn't exist then
|
|||
|
|
sys.excepthook as before.
|
|||
|
|
* When the wrong type is given for a function argument, the
|
|||
|
|
error message now includes the parameter name and function
|
|||
|
|
signature.
|
|||
|
|
* Let SQLite do size checking instead of APSW for strings and
|
|||
|
|
blobs.
|
|||
|
|
* Added :meth:`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.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Mon Dec 5 20:22:14 UTC 2022 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.40.0.0:
|
|||
|
|
* Fixed regression in statement cache update (version 3.38.1-r1) where
|
|||
|
|
trailing whitespace in queries would be incorrectly treated as
|
|||
|
|
incomplete execution (APSW issue 376)
|
|||
|
|
* Added Various interesting and useful bits of functionality (APSW issue
|
|||
|
|
369)
|
|||
|
|
* Added more Pythonic attributes as an alternative to getters and setters,
|
|||
|
|
including Connection.in_transaction, Connection.exectrace,
|
|||
|
|
Connection.rowtrace, Cursor.exectrace, Cursor.rowtrace,
|
|||
|
|
Cursor.connection (APSW issue 371)
|
|||
|
|
* Completed: To the extent permitted by CPython APIs every item has the
|
|||
|
|
same docstring as this documentation. Every API can use named
|
|||
|
|
parameters. The type stubs cover everything including constants. The
|
|||
|
|
type stubs also include documentation for everything, which for example
|
|||
|
|
Visual Studio Code displays as you type or hover. There is a single
|
|||
|
|
source of documentation in the source code, which is then automatically
|
|||
|
|
extracted to make this documentation, docstrings, and docstrings in the
|
|||
|
|
type stubs.
|
|||
|
|
* Example/Tour updated and appearance improved (APSW issue 367).
|
|||
|
|
* Added Connection.cache_stats() to provide more information about the
|
|||
|
|
statement cache.
|
|||
|
|
* Cursor.execute() now uses sqlite_prepare_v3 which allows supplying
|
|||
|
|
flags.
|
|||
|
|
* Cursor.execute() has a new can_cache parameter to control whether the
|
|||
|
|
query can use the statement cache. One example use is with authorizers
|
|||
|
|
because they only run during prepare, which doesn’t happen with already
|
|||
|
|
cached statements.
|
|||
|
|
* (The Cursor.execute() additional parameters are keyword only and also
|
|||
|
|
present in Cursor.executemany(), and the corresponding
|
|||
|
|
Connection.execute() and Connection.executemany() methods.)
|
|||
|
|
* Added Cursor.is_readonly, Cursor.is_explain, and Cursor.expanded_sql.
|
|||
|
|
* Updated processing named bindings so that types registered with
|
|||
|
|
collections.abc.Mapping (such as collections.UserDict) will also be
|
|||
|
|
treated as dictionaries. (APSW issue 373)
|
|||
|
|
* Test no longer fails if APSW was compiled without
|
|||
|
|
SQLITE_ENABLE_COLUMN_METADATA but sqlite3 was separately compiled with
|
|||
|
|
it. APSW should be compiled with the same flags as sqlite3 to match
|
|||
|
|
functionality and APIs. (APSW issue 363)
|
|||
|
|
* –use-system-sqlite-config setup.py build_ext option added to allow
|
|||
|
|
Matching APSW and SQLite options. (APSW issue 364)
|
|||
|
|
* Source ▪ Downloads ▪ Changelogs ▪ Documentation
|
|||
|
|
* PyPI now includes Python 3.11 builds.
|
|||
|
|
* Instead of using scripts, you can now run several tools directly:
|
|||
|
|
* tests: python3 -m apsw.tests [options]
|
|||
|
|
* tracer: python3 -m apsw.trace [options]
|
|||
|
|
* speed tester: python3 -m apsw.speedtest [options]
|
|||
|
|
* shell: python3 -m apsw [options]
|
|||
|
|
* The shell class has moved from apsw.Shell to apsw.shell.Shell (APSW
|
|||
|
|
issue 356). You can still reference it via the old name (ie existing
|
|||
|
|
code will not break, except on Python 3.6).
|
|||
|
|
* Shell: On Windows the native console support for colour is now used
|
|||
|
|
(previously a third party module was supported).
|
|||
|
|
* You can use –definevalues in setup.py build_ext to provide compiler
|
|||
|
|
defines used for configuring SQLite. (APSW issue 357)
|
|||
|
|
* If SQLITE_ENABLE_COLUMN_METADATA is enabled then Cursor.description_full
|
|||
|
|
is available providing all the column metadata available. (APSW issue
|
|||
|
|
354)
|
|||
|
|
* Connection.cursor_factory attribute is now present and is used when
|
|||
|
|
Connection.cursor() is called. Added Connection.execute() and
|
|||
|
|
Connection.executemany() which automatically obtain the underlying
|
|||
|
|
cursor. See customizing connections and cursors in the Tips. (APSW issue
|
|||
|
|
361)
|
|||
|
|
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Mon Jan 17 20:40:34 UTC 2022 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- update to 3.37.0-r1:
|
|||
|
|
* Allow breaking of reference cycles between objects that contain a
|
|||
|
|
Connection or Cursor
|
|||
|
|
* Fixed custom VFS extension loading failure could leave the error message
|
|||
|
|
unterminated
|
|||
|
|
* Updated size of mutex array used by the fork checker
|
|||
|
|
* Connections are opened with SQLITE_OPEN_EXRESCODE so open errors will also
|
|||
|
|
include extended result codes
|
|||
|
|
* Connection.changes() and Connection.totalchanges() use the new SQLite APIs
|
|||
|
|
that return 64 bit values
|
|||
|
|
* Added Connection.autovacuum_pages()
|
|||
|
|
* Implemented Connection.serialize() and Connection.deserialize().
|
|||
|
|
* Allow any subclass of VFS to implement WAL, not just direct subclasses
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Fri Jun 25 06:20:00 UTC 2021 - ecsos <ecsos@opensuse.org>
|
|||
|
|
|
|||
|
|
- Update to 3.35.4-r1:
|
|||
|
|
- Updates for SQLite download url (the year is part of the urls).
|
|||
|
|
- Added enable flag for built-in SQL math functions, and enable
|
|||
|
|
it by default with –enable-all-extensions.
|
|||
|
|
- Use the newer buffer API for Python 3
|
|||
|
|
(old API removed in Python 3.10).
|
|||
|
|
- Fix loadable extensions are missing,
|
|||
|
|
so insert --enable-all-extensions and --enable=load_extension.
|
|||
|
|
See: https://rogerbinns.github.io/apsw/build.html#building
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Dec 29 13:46:03 UTC 2020 - Dirk Müller <dmueller@suse.com>
|
|||
|
|
|
|||
|
|
- udpate to 3.34.0-r1:
|
|||
|
|
* Windows MSI installer files are now provided
|
|||
|
|
* Added Connection.txn_state()
|
|||
|
|
* Added constants: SQLITE_IOERR_CORRUPTFS
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Sep 22 11:54:56 UTC 2020 - Tomáš Chvátal <tchvatal@suse.com>
|
|||
|
|
|
|||
|
|
- Fix the source url to really match reality
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Sep 22 10:29:18 UTC 2020 - Hans-Peter Jansen <hpj@urpla.net>
|
|||
|
|
|
|||
|
|
- Update to 3.33.0-r1:
|
|||
|
|
* Small performance improvement in string handling
|
|||
|
|
* apsw module exposes Cursor, Blob, and Backup types (issue #273)
|
|||
|
|
* pkg-config is used to detect International Components for
|
|||
|
|
Unicode (ICU) sdk when the SQLite ICU extension is enabled. It
|
|||
|
|
falls back to icu-config as before. (issue #268).
|
|||
|
|
- Update to 3.32.2-r2:
|
|||
|
|
* Added some constants
|
|||
|
|
* Minor documentation updates
|
|||
|
|
- Fix source URL
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Mar 3 09:44:34 UTC 2020 - Tomáš Chvátal <tchvatal@suse.com>
|
|||
|
|
|
|||
|
|
- Update the sqlite dependency
|
|||
|
|
- Update to 3.31.1:
|
|||
|
|
* Fix deprecated universal newline use in shell (#283)
|
|||
|
|
* Shell now uses pragma function_list to get list of functions for tab completion
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Feb 4 19:50:05 UTC 2020 - Ondřej Súkup <mimi.vx@gmail.com>
|
|||
|
|
|
|||
|
|
- update to 3.30.1-r1
|
|||
|
|
- drop 0002-Skip-one-test-on-python3.8.patch
|
|||
|
|
0001-py3.8-avoid-invalid-escapes.patch
|
|||
|
|
* Updated hashing of SQL statements
|
|||
|
|
* Updated Connection.config() with all current SQLITE_DBCONFIG constants
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Sep 10 13:32:46 UTC 2019 - Tomáš Chvátal <tchvatal@suse.com>
|
|||
|
|
|
|||
|
|
- Add more py3.8 patches:
|
|||
|
|
* 0001-py3.8-avoid-invalid-escapes.patch
|
|||
|
|
* 0002-Skip-one-test-on-python3.8.patch
|
|||
|
|
- Remove patch obsoleted by above python38.patch
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Thu Jul 4 13:10:16 UTC 2019 - Tomáš Chvátal <tchvatal@suse.com>
|
|||
|
|
|
|||
|
|
- Update to 3.28.0-r1:
|
|||
|
|
* No changelog
|
|||
|
|
- Add patch to build with python 3.8:
|
|||
|
|
* python38.patch
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Thu Aug 31 16:45:50 UTC 2017 - toddrme2178@gmail.com
|
|||
|
|
|
|||
|
|
- Update to version 3.9.2-r1
|
|||
|
|
* No changelog
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Thu Aug 24 13:32:48 UTC 2017 - jmatejek@suse.com
|
|||
|
|
|
|||
|
|
- singlespec auto-conversion
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Oct 15 13:04:33 UTC 2013 - tchvatal@suse.com
|
|||
|
|
|
|||
|
|
- Downgrade to 3.7.17 so we build on 13.1 too.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Oct 15 12:56:58 UTC 2013 - tomas.chvatal@gmail.com
|
|||
|
|
|
|||
|
|
- Fix file collision between doc and normal
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Mon Oct 14 11:46:39 UTC 2013 - tchvatal@suse.com
|
|||
|
|
|
|||
|
|
- Version bump to 3.8.0.2-r1 to use latest sqlite queries.
|
|||
|
|
- Drop the macroed commands in favor of normal ones
|
|||
|
|
- Drop clean section
|
|||
|
|
- Write fully what documents go where.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Wed Oct 9 17:32:14 UTC 2013 - hrvoje.senjan@gmail.com
|
|||
|
|
|
|||
|
|
- Drop unused tarballs, defines and checks for obsolete openSUSE versions
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Tue Sep 3 10:31:58 UTC 2013 - jw@suse.com
|
|||
|
|
|
|||
|
|
- osc service localrun format_spec_file
|
|||
|
|
to add comments and such.
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Mon Dec 12 19:35:39 UTC 2011 - pascal.bleser@opensuse.org
|
|||
|
|
|
|||
|
|
- build for all supported versions from a single spec
|
|||
|
|
- link dynamically against the sqlite3 version that ships with each distro
|
|||
|
|
version, rather than using amalgamation: this is required by s3ql
|
|||
|
|
|
|||
|
|
-------------------------------------------------------------------
|
|||
|
|
Mon Aug 9 15:40:35 UTC 2010 - pascal.bleser@opensuse.org
|
|||
|
|
|
|||
|
|
- initial package (3.7.0.1-r1)
|
|||
|
|
|
|||
|
|
|