9b633c6a33
- 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
Dirk Mueller2025-12-12 10:56:31 +00:00
f84e2e7679
- 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)
Daniel Garcia2025-08-05 10:44:08 +00:00
bbd7f0346c
Accepting request 1204392 from devel:languages:python
Ana Guerrero2024-09-30 13:38:11 +00:00
176412f1ba
- update to 3.46.1.0: * The shell dump command outputs the application_id in addition to the user_version.
Dirk Mueller2024-09-28 19:16:51 +00:00
f8f5f03903
- 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)
Dirk Mueller2024-06-30 21:35:14 +00:00
f6d1ccfb4f
Accepting request 1178935 from devel:languages:python
Ana Guerrero2024-06-06 10:34:29 +00:00
62b8e2b5dc
- 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)
Dirk Mueller2024-06-06 08:36:07 +00:00
83545c65f4
Accepting request 1169376 from devel:languages:python
Ana Guerrero2024-04-21 18:27:39 +00:00
65d182c371
- update to 3.45.3.0: * No APSW changes.
Dirk Mueller2024-04-20 14:09:27 +00:00
1e8361fb2d
Accepting request 1158947 from devel:languages:python
Ana Guerrero2024-03-18 15:47:01 +00:00
29ef17d036
- 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.
Dirk Mueller2024-03-18 10:28:24 +00:00
acc659f27f
Accepting request 1140101 from devel:languages:python
Ana Guerrero2024-01-21 22:08:38 +00:00
f01e91e3c7
Accepting request 1130519 from devel:languages:python
Ana Guerrero2023-12-03 19:49:15 +00:00
9cd8ed417c
- 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)
Dirk Mueller2023-12-02 20:19:17 +00:00
407313158e
Accepting request 1126235 from devel:languages:python
Ana Guerrero2023-11-15 20:08:27 +00:00
f01dd1b0da
- 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. - Reduced overhead of the Column method when using Connection or Cursor - Fix loadable extensions are missing, * Added constants: SQLITE_IOERR_CORRUPTFS
Dirk Mueller2023-11-14 15:57:18 +00:00
627036af2a
Accepting request 1116041 from devel:languages:python
Ana Guerrero2023-10-22 19:01:33 +00:00
9bcf386c18
Accepting request 1115988 from home:ecsos:python
Matej Cepl2023-10-06 12:49:04 +00:00
38a8a424e6
Accepting request 1100912 from devel:languages:python
Ana Guerrero2023-07-27 14:51:48 +00:00
ef40c4775a
- Make the test suite pass again (gh#rogerbinns/apsw#462).
Matej Cepl2023-07-26 18:05:20 +00:00
deddcf40ce
- 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.
Matej Cepl2023-07-26 14:59:16 +00:00
f2e2578020
- 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.
Dirk Mueller2023-05-27 21:03:46 +00:00
2970bdf4ab
- 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.
Dirk Mueller2023-04-16 09:23:29 +00:00
abd0edf52f
- 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.
Dirk Mueller2023-02-10 10:11:48 +00:00
23416d91ef
- 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.)
Dirk Mueller2022-12-05 21:13:25 +00:00
25a3b98624
- 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
Dirk Mueller2022-01-17 20:43:05 +00:00
73b4c204c2
- 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
Tomáš Chvátal
2020-03-03 09:51:19 +00:00
4004891b38
- 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
Ondřej Súkup2020-02-04 19:58:46 +00:00
Ana Guerrero
Dirk Mueller
Adrian Schröter
Dominique Leuenberger
Daniel Garcia
Matej Cepl
Tomáš Chvátal
Ondřej Súkup
Todd R
Tomáš Chvátal
Denisart Benjamin
Sascha Peilicke
Pascal Bleser