asyncio bridge to the standard sqlite3 module
Project description
aiosqlite provides a friendly, async interface to sqlite databases.
It replicates the standard sqlite3 module, but with async versions of all the standard connection and cursor methods, plus context managers for automatically closing connections and cursors:
async with ezsqlite3.connect(...) as db:
await db.execute("INSERT INTO some_table ...")
await db.commit()
async with db.execute("SELECT * FROM some_table") as cursor:
async for row in cursor:
...
It can also be used in the traditional, procedural manner:
db = await ezsqlite3.connect(...)
cursor = await db.execute('SELECT * FROM some_table')
row = await cursor.fetchone()
rows = await cursor.fetchall()
await cursor.close()
await db.close()
aiosqlite also replicates most of the advanced features of sqlite3:
async with ezsqlite3.connect(...) as db:
db.row_factory = aiosqlite.Row
async with db.execute('SELECT * FROM some_table') as cursor:
async for row in cursor:
value = row['column']
await db.execute('INSERT INTO foo some_table')
assert db.total_changes > 0
Install
aiosqlite is compatible with Python 3.8 and newer. You can install it from PyPI:
$ pip install ezsqlite3
Details
aiosqlite allows interaction with SQLite databases on the main AsyncIO event loop without blocking execution of other coroutines while waiting for queries or data fetches. It does this by using a single, shared thread per connection. This thread executes all actions within a shared request queue to prevent overlapping actions.
Connection objects are proxies to the real connections, contain the shared execution thread, and provide context managers to handle automatically closing connections. Cursors are similarly proxies to the real cursors, and provide async iterators to query results.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for ezsqlite3-0.20.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ab9a0887e5db603c6257e64e5e7e81d84046793a4a5237363791299e14024982 |
|
MD5 | aa8cb529883ef149ebeeed2d1e73fd06 |
|
BLAKE2b-256 | 2b3c58b7901f836b1052518b1a9a40639986e4263c4e54240c11b102dc6da302 |