./databases/py-apsw, Python wrapper for SQLite

[ Image CVSweb ] [ Image Homepage ] [ Image RSS ] [ Image Required by ]

Branch: CURRENT, Version: 3.53.4.0, Package name: py313-apsw-3.53.4.0, Maintainer: 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.


Required to run:
[databases/sqlite3] [lang/python310]

Master sites:

Filesize: 2808.321 KB

Version history: (Expand)

CVS history: (Expand)


   2026-08-11 07:35:18 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-apsw: updated to 3.53.4.0

3.53.4.0

Blob implements io.RawIOBase allowing use by other modules expecting file like
objects, such as compression. Several methods and attributes are added, and
Blob.write() now returns the size written (used to be None).
   2026-07-15 08:02:33 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-apsw: updated to 3.53.3.1

3.53.3.1

Fix an issue that could occur with connections and module unload ordering during \ 
finalization.
   2026-07-03 08:09:13 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-apsw: updated to 3.53.3.0

3.53.3.0

pyodide (web assembly) builds are now published to pypi, thanks to version 4 of \ 
cibuildwheel.

Async breaking changes: This SQLite release requires the database mutex for some \ 
APIs that it did not before. The following were direct values, but now must be \ 
awaited: Connection.changes() Connection.get_autocommit() \ 
Connection.in_transaction Connection.last_insert_rowid() \ 
Connection.total_changes()

The closure extension was removed from SQLite extra by SQLite. Common table \ 
expressions are a better approach.

Remove the logger on module unload (APSW issue 620)
   2026-06-05 09:04:26 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-apsw: updated to 3.53.2.0

3.53.2.0

Reflects changes and updates in SQLite extra. The sqlite3_scrub binary has been \ 
removed - use VACUUM INTO instead.
   2026-05-06 10:24:12 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-apsw: updated to 3.53.1.0

3.53.1.0

Async cursor iteration: Cursor attributes like bindings_names, sql, and \ 
is_readonly will always correctly reflect the current iterated row. Backwards \ 
incompatible change: description, get_description(), and description_full are \ 
now values - ie you can just use them directly and should not await them.
   2026-04-17 14:50:01 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
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
   2026-03-15 10:36:53 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-apsw: updated to 3.51.3.0

3.51.3.0

The SQLite 3.52.0 release was withdrawn, so the corresponding APSW one was too.

Includes all the changes from the 3.52.0.0 release, except SQLITE_UTF8_ZT and \ 
sqlite3_carray_bind_v2.

SQLite extra adds extensions and programs that require the zlib compression \ 
library, notably zipfile and sqlar
   2026-03-11 11:57:18 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
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