Up to [cvs.NetBSD.org] / pkgsrc / databases / py-apsw
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
py-apsw: updated to 3.54.1.0 3.54.1.0 Fixed build failure on recent gcc, due to using header that was included by other headers. (APSW issue 640) Fixed reference count leak due to incorrect reference count handling. The main symptom would be connections not automatically being garbage collected. (APSW issue 641)
py-apsw: updated to 3.53.0.0 3.53.0.0 ChangesetBuilder adds ChangesetBuilder.add_insert(), ChangesetBuilder.add_delete(), ChangesetBuilder.add_update(), and ChangesetBuilder.config(). Added .limit command to the Shell
py-apsw: updated ot 3.52.0.0 3.52.0.0 Comprehensive async support - connections run in a dedicated worker thread with the event loop able to await the results. asyncio, trio (note), and anyio (note) are supported and tested Async callbacks can be used anywhere including: scalar, window, and aggregate functions virtual tables (only the methods you want) apsw.ext.make_virtual_module() VFS (again, only the methods you want) the various other SQLite hooks Cancellations and deadlines (timeouts) from the event loop apply to executing SQL as well as async callbacks Type stubs as used by type checkers and IDEs reflect async usage
py-apsw: updated to 3.51.0.0 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.
py-apsw: updated to 3.50.2.0 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.. 3.50.1.0 No user visible changes. 3.50.0.0 Full support for the Session extension Added Connection.setlk_timeout(), apsw.mapping_setlk_timeout_flags, and enabled the timeout for amalgamation builds such as PyPI. Shell open command allows specifying flags to open a connection, and connection command shows flags used for each open. (APSW issue 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.
Fix PLIST after py-setuptools update; bump depends and revision
py-apsw: updated to 3.47.1.0 3.47.1.0 Documentation on how to build for 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. 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 shows it in a pretty form.
py-apsw: updated to 3.47.0.0 3.47.0.0 Support for Python 3.8 removed (APSW issue 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. Added recursive triggers and optimize to apsw.bestpractice. Multiple callbacks can be present for Connection.trace_v2() with APSW ensuring they are all called (APSW issue 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 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 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 Table class that wraps access to a FTS5 table (including creating one) with search(), more_like(), and query_suggest(). apsw.fts5query can parse, modify, and reconstruct queries. The shell gets a 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).
py-apsw: updated to 3.43.2.0 3.43.2.0 Connection.create_aggregate_function() can take a class with step and final methods. (APSW issue 421) Corrected non PEP 8 compliant names. The old names remain as aliases to the new ones, and your code will not break.
py-apsw: updated to 3.43.0.0 3.43.0.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)
py-apsw: updated to 3.40.0.0 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).
py-apsw: updated to 3.39.2.1 3.39.2.1 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) 3.39.2.0 Version numbering scheme change: Instead of a -r1 style suffix, there is .0 style suffix (APSW issue 340) Updated building for PyPI to include more compiled platforms, including aarch64 (Linux) and universal (MacOS). Windows binaries are no longer separately provided since PyPI has them. When the amalgamation is included into APSW, SQLITE_MAX_ATTACHED is set to 125 if not defined, up from the default of 10. Updated typing information stubs with more detail and include docstrings. This is still ongoing, but core functionality is well covered. (APSW issue 338) (APSW issue 381) Corrected the tips log handler of extended result code (APSW issue 342) Added Connection.db_names() (APSW issue 343)
3.19.3-r1: No APSW changes. Now we're in sync with databases/sqlite3
Import py27-apsw-3.8.4.2pl1 as databases/py-apsw, packaged for wip by rhialto. APSW provides an SQLite 3 wrapper that provides the thinnest layer over the SQLite database library possible. Everything you can do from the SQLite C API, you can do from Python. Although APSW looks vaguely similar to the PEP 249 (DBAPI), it is not compliant with that API because instead it works the way SQLite 3 does.