NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →

PyPI · #367 most downloaded on PyPI

aiosqlite

0.22.161M downloads/moomnilib/aiosqlite ↗New releases in your daily digest, changelog included.

asyncio bridge to the standard sqlite3 module

Last release 9 months ago
23 Dec 2025
Release timing varies
gaps range from 1 weeks to 1.8 years
Nearly every release is documented
notes for 27 of 28 stable releases
Nothing withdrawn
no release was ever pulled
9 years old
28 releases · first in 2017

Release timeline

28 releases since 2017

2017201920212023

Releases

0.22.123 Dec 2025
NOTE: Starting with v0.22.0 , the aiosqlite.Connection object no longer inherits from threading.Thread . If not using aiosqlite as a context manager,
NOTE: Starting with v0.22.0, the aiosqlite.Connection object no longer
inherits from threading.Thread. If not using aiosqlite as a context manager,
clients must await connection.close() or call connection.stop() to ensure
the helper thread is completed and terminated correctly. A ResourceWarning
will be emitted for any connection that is garbage collected without being
closed or stopped.

Added synchronous stop() method to aiosqlite.Connection to enable safe
cleanup and termination of the background thread without dependence
on having an active event loop (#370)
Open source →
Additional notes2 sources agree
Bug fix release

NOTE: Starting with v0.22.0, the aiosqlite.Connection object no longer inherits from threading.Thread. If not using aiosqlite as a context manager, clients must await connection.close() or call connection.stop() to ensure the helper thread is completed and terminated correctly. A ResourceWarning will be emitted for any connection that is garbage collected without being closed or stopped.

Added synchronous stop() method to aiosqlite.Connection to enable safe cleanup and termination of the background thread without dependence on having an active event loop (#370)

$ git shortlog -s v0.22.0...v0.22.1 2 Amethyst Reese

0.22.013 Dec 2025

Support set_authorizer query access controls

Support set_authorizer query access controls (#349)
Wait for transaction queue to complete when closing connection (#305)
Emit warning when connection goes out of scope without being closed (#355)
Remove dependency on typing_extensions (#365)

Open source →

Additional notes2 sources agree

Feature release

Support set_authorizer query access controls (#349)
Wait for transaction queue to complete when closing connection (#305)
Emit warning when connection goes out of scope without being closed (#355)
Remove dependency on typing_extensions (#365)

$ git shortlog -s v0.21.0...v0.22.0
     1	Alec Berryman
     1	Amethyst Reese
     1	David Andreoletti
     1	Markus Heidelberg
     1	beerpsi
    19	dependabot[bot]

Open source →

0.21.03 Feb 2025

Fix: close connection correctly when BaseException raised in connection

Fix: close connection correctly when BaseException raised in connection (#317)
Metadata improvements
Tested and supported on Python 3.13
Drop support for Python 3.8
Drop testing on PyPy

Open source →

Additional notes2 sources agree

Maintenance release

Fix: close connection correctly when BaseException raised in connection (#317)
Metadata improvements
Tested and supported on Python 3.13
Drop support for Python 3.8
Drop testing on PyPy

$ git shortlog -s v0.20.0...v0.21.0
     6	Amethyst Reese
     1	Gabriel
     1	Stanley Kudrow
    11	dependabot[bot]

Open source →

0.20.020 Feb 2024

Connection .close() method is now idempotent

Connection .close() method is now idempotent (#238)
Performance improvements in connection thread and event loop (#213, #271)
Updated contributor guide (#255)
Tested on Python 3.12
Dropped support for Python 3.7 (#230)

Open source →

Additional notes2 sources agree

Feature release

Connection .close() method is now idempotent (#238)
Performance improvements in connection thread and event loop (#213, #271)
Updated contributor guide (#255)
Tested on Python 3.12
Dropped support for Python 3.7 (#230)

$ git shortlog -s v0.19.0...v0.20.0
     6	Amethyst Reese
     4	J. Nick Koston
     1	Waket Zheng
    18	dependabot[bot]
     1	mike bayer
     1	vdergachyov

Open source →

0.19.017 Apr 2023Deprecated

Deprecated: Python 3.7 support will be dropped in v0.20.0

Add support for setting cursor row_factory (#229)
Dropped unused compatibility shims for 3.5 and 3.6
Deprecated: Python 3.7 support will be dropped in v0.20.0

Open source →

Additional notes2 sources agree

Feature release

Add support for setting cursor row_factory (#229)
Dropped unused compatibility shims for 3.5 and 3.6
Deprecated: Python 3.7 support will be dropped in v0.20.0

$ git shortlog -s v0.18.0...v0.19.0
    13	Amethyst Reese
     1	Daniel Baulig
     4	dependabot[bot]

Open source →

0.18.019 Dec 2022

Better type hints for isolation_level ( #172 ) and text_factory

Added support for paramstyle (#197)
Better type hints for isolation_level (#172) and text_factory (#179)
Use stdlib typing module when possible (#114)
Replace aiounittest with stdlib on 3.8+
Docmentation improvements (#108)
Dropped support for Python 3.7, added support for Python 3.10 and 3.11 (#208)

Open source →

Additional notes2 sources agree

Feature release

Added support for paramstyle (#197)
Better type hints for isolation_level (#172) and text_factory (#179)
Use stdlib typing module when possible (#114)
Replace aiounittest with stdlib on 3.8+
Docmentation improvements (#108)
Dropped support for Python 3.7, added support for Python 3.10 and 3.11 (#208)

$ git shortlog -s v0.17.0...v0.18.0
    31	Amethyst Reese
     3	Nico0 Smart
     3	Nicolas Martinez
    37	dependabot[bot]
     2	pandaninjas
     6	pyup.io bot
     1	vexelnet

Open source →

0.17.022 Feb 2021

Connection objects now raise ValueError when closed and a command is executed

Connection objects now raise ValueError when closed and a command is executed (#79)
Fix documented examples in readme (#104)

Open source →

Additional notes2 sources agree

Feature release

Connection objects now raise ValueError when closed and a command is executed (#79)
Fix documented examples in readme (#104)

$ git shortlog -s v0.16.1...v0.17.0
     3	Amethyst Reese
     5	Mariano Sorgente
     1	Nuno André
     1	pyup.io bot

Open source →

0.16.123 Jan 2021

Reduce logging severity for exceptions

Reduce logging severity for exceptions (#93)
Stop logging result objects; they can be big (#102)

Open source →

Additional notes2 sources agree

Bug fix release

Reduce logging severity for exceptions (#93)
Stop logging result objects; they can be big (#102)

$ git shortlog -s v0.16.0...v0.16.1
     1	Alexei Chetroi
     3	Amethyst Reese
     3	pyup.io bot

Open source →

0.16.02 Nov 2020

Improved performance for async iteration on cursors ( #34 , #86 )

Improved performance for async iteration on cursors (#34, #86)
Support for deterministic user functions in Python 3.8+ (#81, #83, #84)
Reduced logging severity for exceptions returned from children (#75, #76)
Fix InvalidStateError when setting future results (#80, #89)
Allow user to catch exceptions from close() (#68, #90)
Tested under Python 3.9 (#91)

Open source →

Additional notes2 sources agree

Feature release

Improved performance for async iteration on cursors (#34, #86)
Support for deterministic user functions in Python 3.8+ (#81, #83, #84)
Reduced logging severity for exceptions returned from children (#75, #76)
Fix InvalidStateError when setting future results (#80, #89)
Allow user to catch exceptions from close() (#68, #90)
Tested under Python 3.9 (#91)

$ git shortlog -s v0.15.0...v0.16.0
    14	Amethyst Reese
     3	Caleb Hattingh
     1	Groosha
     1	Lonami
     4	Lonami Exo
     4	ZsoltM
     1	pyup.io bot

Open source →

0.15.015 Jul 2020Deprecated

Deprecated loop parameter to connect() and Connection

Support for accessing connections from multiple event loops
Fixed type annotations for connection methods returning cursors
Move cursors into separate module from connections
Deprecated loop parameter to connect() and Connection

Open source →

Additional notes2 sources agree

Feature release

Support for accessing connections from multiple event loops
Fixed type annotations for connection methods returning cursors
Move cursors into separate module from connections
Deprecated loop parameter to connect() and Connection

$ git shortlog -s v0.14.1...v0.15.0
     7	Amethyst Reese

Open source →

0.14.111 Jul 20202 sources agree

Remove debugging print() calls. Oops!

Bugfix release

Remove debugging print() calls. Oops! (#72)

$ git shortlog -s v0.14.0...v0.14.1
     2	Amethyst Reese
     1	Spyros Roum

Open source →

0.14.010 Jul 20202 sources agree

Connection.backup() now supported

Feature release

Connection.backup() now supported (#71)
PEP 561 support added to mark the package as type annotated (#69)
Better/fixed type annotations for context managers (#70)

$ git shortlog -s v0.13.0...v0.14.0
     5	Amethyst Reese
     3	montag451

Open source →

0.13.06 May 20202 sources agree

cursor.execute*() now returns the cursor to match sqlite3 API

Feature release

cursor.execute*() now returns the cursor to match sqlite3 API (#62)
Connection.set_trace_callback() now supported (#62)
Connection.iterdump() is now supported (#66)
Fixed possible hung thread if connection failed (#55)
Dropped support for Python 3.5

$ git shortlog -s v0.12.0...v0.13.0
    32	Amethyst Reese
     1	pyup.io bot
     5	shipmints

Open source →

0.12.08 Apr 20202 sources agree

Add support for custom functions

Feature Release

Add support for custom functions (#58)
Official support for Python 3.8

$ git shortlog -s v0.11.0...v0.12.0
     4	Amethyst Reese
     1	dmitrypolo
     3	pyup.io bot

Open source →

0.11.012 Dec 20192 sources agree

Added support for set_progress_handler

Feature release v0.11.0

Added support for set_progress_handler (#49)
Improved and updated documentation

$ git shortlog -s v0.10.0...v0.11.0
    11	Amethyst Reese
     4	Stanislas
     2	Vladislav Yarmak
     1	pyup-bot
     5	tat2grl85

Open source →

0.10.08 Apr 20192 sources agree

Support using connections without context managers

Feature release v0.10.0:

Support using connections without context managers (#29)
Include test suite in aiosqlite package

$ git shortlog -s v0.9.0...v0.10.0
    16	Amethyst Reese
     1	Simon Willison
     1	dark0ghost

Open source →

0.9.07 Feb 20192 sources agree

Fixed support for type annotations on early Python 3.5

Feature release v0.9.0:

Support for sqlite extensions
Fixed support for type annotations on early Python 3.5

$ git shortlog -s v0.8.1...v0.9.0
     2	Alexander Lyon
     3	Amethyst Reese

Open source →

0.8.128 Dec 20182 sources agree

Fix connections to byte string db locations

Bug fix release v0.8.1:

Fix connections to byte string db locations (#20)

$ git shortlog -s v0.8.0...v0.8.1
     6	Amethyst Reese
     1	DevilXD

Open source →

0.8.01 Nov 20182 sources agree

Use futures instead of polling for connections/cursors. This will significantly reduce time spent blocking the primary event loop, resulting in better

Major release v0.8.0:

Use futures instead of polling for connections/cursors. This will significantly reduce time spent blocking the primary event loop, resulting in better performance of asyncio applications using aiosqlite.

$ git shortlog -s v0.7.0...v0.8.0
     3	Amethyst Reese
     2	Matthew Schubert

Open source →

0.7.014 Oct 20182 sources agree

Added macros for combined insert/id and select/fetch

Feature release v0.7.0:

Added macros for combined insert/id and select/fetch
Better perf testing output

$ git shortlog -s v0.6.0...v0.7.0
     4	Amethyst Reese
     1	Grigi

Open source →

0.6.019 Sept 20182 sources agree

Performance improvements for atomic or fast queries

Feature release v0.6.0:

Performance improvements for atomic or fast queries
Support passing Path-like objects to aiosqlite.connect
Unit tests now use aiounittest instead of a custom test harness
Limited set of performance tests now available

$ git shortlog -s v0.5.0...v0.6.0
     8	Amethyst Reese
     1	Grigi

Open source →

0.5.011 Sept 20182 sources agree

More aliases from sqlite3, including Row, errors, and register_*

Feature release v0.5.0:

More aliases from sqlite3, including Row, errors, and register_*
Additional connection properties for row/text factory, total changes
Better readme

$ git shortlog -s v0.4.0...v0.5.0
     6	Amethyst Reese

Open source →

0.4.03 Sept 20182 sources agree

Enable using a custom asyncio event loop

Feature release v0.4.0:

Enable using a custom asyncio event loop
Increase performance by decreasing sleep time

$ git shortlog -s v0.3.0...v0.4.0
    15	Amethyst Reese
     1	Justin Kula
     1	Richard Schwab

Open source →

0.3.011 Apr 20182 sources agree

Cursors can be used as context managers

Feature release v0.3.0:

Cursors can be used as context managers

$ git shortlog -s v0.2.2...v0.3.0
     6	Amethyst Reese
     5	Linus Lewandowski

Open source →

0.2.25 Apr 20182 sources agree

Markdown readme, release via twine

Minor release:

Correct aiosqlite.version
Markdown readme, release via twine

$ git shortlog -s v0.2.1...v0.2.2
     5	Amethyst Reese

Open source →

0.2.14 Apr 20182 sources agree

Increase polling speed on event loop

Minor release v0.2.1:

Increase polling speed on event loop
Using black and pylint

$ git shortlog -s v0.2.0...v0.2.1
     8	Amethyst Reese
     2	Pavol Vargovcik

Open source →