summaryrefslogtreecommitdiff
path: root/databases/py-apsw
AgeCommit message (Collapse)AuthorFilesLines
2022-11-28py-apsw: updated to 3.40.0.0adam3-11/+11
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).
2022-11-23massive revision bump after textproc/icu updateadam1-1/+2
2022-10-10py-apsw: updated to 3.39.4.0adam2-6/+6
3.39.4.0 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)
2022-09-12py-apsw: updated to 3.39.3.0adam2-7/+7
3.39.3.0 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)
2022-09-09py-apsw: does not support python 2.x any longerwiz1-1/+3
2022-09-05py-apsw: updated to 3.39.2.1adam3-11/+27
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)
2022-04-18revbump for textproc/icu updateadam1-2/+2
2022-01-16databases/py-apsw: add --enable=load_extensionrhialto1-1/+4
This will be needed for calibre 5.x. There is also --enable-all-extensions but I left that off for now.
2022-01-11py-apsw: updated to 3.37.0adam2-8/+7
3.37.0-r1 Allow breaking of reference cycles between objects that contain a Connection or Cursor, and also use callbacks from that object (eg busy handler). This is the last release supporting Python 2 and Python 3 before 3.7. If you still use those Python versions then you should pin to this APSW version. (More information). Windows Python 3.10 binaries are available to download. The .exe format is no longer available with this Python version. 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 (ie can now return values greater than 2 billion). Added Connection.autovacuum_pages(). Added constants: SQLITE_CONSTRAINT_DATATYPE, SQLITE_OPEN_EXRESCODE
2022-01-04*: bump PKGREVISION for egg.mk userswiz1-2/+2
They now have a tool dependency on py-setuptools instead of a DEPENDS
2021-12-08revbump for icu and libffiadam1-1/+2
2021-10-26databases: Replace RMD160 checksums with BLAKE2s checksumsnia1-2/+2
All checksums have been double-checked against existing RMD160 and SHA512 hashes The following distfiles could not be fetched (some may be only fetched conditionally): ./databases/cstore/distinfo D6.data.ros.gz ./databases/cstore/distinfo cstore0.2.tar.gz ./databases/cstore/distinfo data4.tar.gz
2021-10-07databases: Remove SHA1 distfile hashesnia1-2/+1
2021-08-23py-apsw: updated to 3.36.0adam2-9/+8
3.36.0-r1 Implemented Connection.serialize() and Connection.deserialize(). They turn a database into bytes, and bytes into a database respectively. Allow any subclass of VFS to implement WAL, not just direct subclasses. (APSW issue 311) Added constants: SQLITE_FCNTL_EXTERNAL_READER, SQLITE_FCNTL_CKSM_FILE
2021-04-21revbump for textproc/icuadam1-1/+2
2021-04-16py-apsw: updated to 3.35.4adam2-7/+7
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).
2021-01-03py-apsw: updated to 3.34.0adam2-8/+7
3.34.0-r1 Windows MSI installer files are now provided in addition to the exe files (APSW issue 294), as well as wheels for Python 3.6+. Python 3.9 binaries are also now available. The wheels can be installed via pip. Added Connection.txn_state() Added constants: SQLITE_IOERR_CORRUPTFS
2020-11-05*: Recursive revbump from textproc/icu-68.1ryoon1-1/+2
2020-09-18py-apsw: updated to 3.33.0adam2-7/+7
3.33.0-r1 Small performance improvement in string handling apsw module exposes Cursor, Blob, and Backup types (APSW issue 273) pkg-config is used to detect International Components for Unicode (ICU) sdk when the SQLite ICU extension <https://www.sqlite.org/src/artifact?ci=trunk&filename=ext/icu/README.txt>`___ is enabled. It falls back to icu-config as before.. Added constants: SQLITE_OPEN_SUPER_JOURNAL
2020-06-10py-apsw: updated to 3.32.2adam2-9/+8
3.32.2-r1 Added constants: SQLITE_IOERR_DATA, SQLITE_CORRUPT_INDEX, SQLITE_BUSY_TIMEOUT, SQLITE_FCNTL_CKPT_START, SQLITE_FCNTL_RESERVE_BYTES
2020-06-02Revbump for icuadam1-2/+2
2020-04-12Recursive revision bump after textproc/icu updateadam1-1/+2
2020-03-15py-apsw: updated to 3.31.1adam2-7/+7
3.31.1-r1 Various updates due to year change Fix deprecated universal newline use in shell Shell now uses pragma function_list to get list of functions for tab completion Added constants: SQLITE_DBCONFIG_TRUSTED_SCHEMA, SQLITE_DBCONFIG_LEGACY_FILE_FORMAT, SQLITE_CONSTRAINT_PINNED, SQLITE_OK_SYMLINK, SQLITE_CANTOPEN_SYMLINK, SQLITE_FCNTL_CKPT_DONE, SQLITE_OPEN_NOFOLLOW, SQLITE_VTAB_DIRECTONLY
2019-11-06py-apsw: updated to 3.30.1adam2-8/+8
3.30.1-r1 Added constants: SQLITE_DBCONFIG_ENABLE_VIEW Updated hashing of SQL statements Python 3.8 Windows binaries available.
2019-10-19py-apsw: updated to 3.29.0adam2-8/+8
3.29.0: Added constants: SQLITE_DBCONFIG_DQS_DML, SQLITE_DBCONFIG_DQS_DDL, SQLITE_DBCONFIG_LEGACY_ALTER_TABLE Updated Connection.config() with all current SQLITE_DBCONFIG constants. Also fixes APSW issue 249
2019-06-18py-apsw: updated to 3.28.0adam2-9/+8
3.28.0-r1 Added constant: SQLITE_DBCONFIG_WRITABLE_SCHEMA
2019-04-03Recursive revbump from textproc/icuryoon1-1/+2
2019-03-27py-apsw: requires sqlite3 3.27 or newerwiz1-2/+2
2019-03-21py-apsw: updated to 3.27.2adam2-7/+7
3.27.2-r1 Added constants: * SQLITE_CONFIG_MEMDB_MAXSIZE, SQLITE_FCNTL_SIZE_LIMIT Added support for the geopoly extension Removed hash optimisation that isn’t useful any more
2019-01-08py-apsw: updated to 3.26.0adam2-8/+7
3.26.0-r1 Added constant: SQLITE_DBCONFIG_DEFENSIVE
2018-12-09revbump after updating textproc/icuadam1-1/+2
2018-11-20py-apsw: updated to 3.25.1adam2-8/+8
3.25.1: Added constants: SQLITE_INDEX_CONSTRAINT_FUNCTION, SQLITE_CANTOPEN_DIRTYWAL, SQLITE_ERROR_SNAPSHOT, SQLITE_FCNTL_DATA_VERSION Shell output mode now has lines and columns for compatibility (APSW issue 214) Example now runs under both Python 2 and 3.
2018-07-20py-apsw: updated to 3.24.0adam2-9/+8
3.24.0-r1 Added constants: * SQLITE_DBCONFIG_RESET_DATABASE, and support for it in Connection.config() * SQLITE_LOCKED_VTAB, and SQLITE_CORRUPT_SEQUENCE extended result codes Added keywords and updated the shell to use it.
2018-07-20Recursive revbump from textproc/icu-62.1ryoon1-1/+2
2018-07-09py-apsw: updated to 3.23.1adam2-7/+7
3.23.1: Added constants: SQLITE_DBSTATUS_CACHE_SPILL, SQLITE_FCNTL_LOCK_TIMEOUT
2018-04-17py-apsw: updated to 3.22.0adam2-10/+8
3.22.0: Added constants: SQLITE_DBCONFIG_TRIGGER_EQP, SQLITE_DBCONFIG_MAX SQLITE_READONLY_CANTINIT, SQLITE_ERROR_RETRY, SQLITE_ERROR_MISSING_COLLSEQ, SQLITE_READONLY_DIRECTORY
2018-04-14revbump after icu updateadam1-2/+2
2017-11-30Revbump after textproc/icu updateadam1-1/+2
2017-11-15py-apsw: updated to 3.21.0adam2-9/+8
3.21.0: Added constants: SQLITE_INDEX_CONSTRAINT_ISNULL, SQLITE_INDEX_CONSTRAINT_ISNOT, SQLITE_INDEX_CONSTRAINT_ISNOTNULL, SQLITE_INDEX_CONSTRAINT_IS and SQLITE_INDEX_CONSTRAINT_NE SQLITE_CONFIG_SMALL_MALLOC SQLITE_IOCAP_BATCH_ATOMIC SQLITE_IOERR_ROLLBACK_ATOMIC, SQLITE_IOERR_COMMIT_ATOMIC and SQLITE_IOERR_BEGIN_ATOMIC SQLITE_FCNTL_COMMIT_ATOMIC_WRITE, SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE and SQLITE_FCNTL_BEGIN_ATOMIC_WRITE
2017-09-18revbump for requiring ICU 59.xmaya1-1/+2
2017-09-013.20.1:adam2-7/+7
Added SQLITE_DBCONFIG_ENABLE_QPSG constant. Added shell .open command (APSW issue 240)
2017-07-29Needs at least sqlite-3.18.wiz1-2/+2
2017-07-263.19.3-r1:adam3-15/+20
No APSW changes. Now we're in sync with databases/sqlite3
2017-04-22Revbump after icu updateadam1-2/+2
2016-12-04Recursive revbump from textproc/icu 58.1ryoon1-2/+2
2016-04-11Recursive revbump from textproc/icu 57.1ryoon1-2/+2
2015-11-03Add SHA512 digests for distfiles for databases categoryagc1-1/+2
Problems found with existing distfiles: distfiles/D6.data.ros.gz distfiles/cstore0.2.tar.gz distfiles/data4.tar.gz distfiles/sphinx-2.2.7-release.tar.gz No changes made to the cstore or mariadb55-client distinfo files. Otherwise, existing SHA1 digests verified and found to be the same on the machine holding the existing distfiles (morden). All existing SHA1 digests retained for now as an audit trail.
2015-10-10Recursive revbump from textproc/icuryoon1-2/+2
2015-04-06Revbump after updating textproc/icuadam1-2/+2
2014-12-31Improve EGG_NAME default to work for packages with '-' in their name.wiz1-3/+1
Remove now unnecessary overrides in various packages.
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-16 04:47:28 +0000