aioduckdb: DuckDB for AsyncIO
aioduckdb provides a friendly, async interface to DuckDB databases. It has been ported from the original aiosqlite module.
It replicates the duckdb module, but with async versions of all the standard connection and cursor methods, plus context managers for automatically closing connections and cursors:
async with aioduckdb.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 aioduckdb.connect(...)
cursor = await db.execute('SELECT * FROM some_table')
row = await cursor.fetchone()
rows = await cursor.fetchall()
await cursor.close()
await db.close()
Install
aioduckdb is compatible with Python 3.6 and newer. ~~You can install it from PyPI:~~ Not currently on PyPI.
Details
aioduckdb allows interaction with DuckDB 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.
License
aioduckdb is copyright Salvador Pardiñas, and licensed under the MIT license. I am providing code in this repository to you under an open source license. This is my personal repository; the license you receive to my code is from me and not from my employer. See the LICENSE file for details.
Big thanks to Amethyst Reese for the original aiosqlite repository.
1 maintainer
Metadata
1 maintainer
Release files for aioduckdb 0.1.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| aioduckdb-0.1.0.tar.gz | 89.7 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| aioduckdb-0.1.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 168.9 kB
Release files / aioduckdb-0.1.0.tar.gz
| Download URL | aioduckdb-0.1.0.tar.gz |
|---|---|
| Size | 89.7 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
9171ffa590ac2056a1eca357c397205575bad973e35ffad59bf7fc291ab73456
|
|
BLAKE2b-256 checksum How to use checksums |
6e79b88f9db1eb97bf444381c8ded0cd0132580834b843cd08a7f87dd00a08b4
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
python-requests/2.28.2
|
Release files / aioduckdb-0.1.0-py3-none-any.whl
| Download URL | aioduckdb-0.1.0-py3-none-any.whl |
|---|---|
| Size | 79.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
27b6a2a40d51cfe5dc7733ea6437f503e6a8b152c8fddf16c34635e5ea918d52
|
|
BLAKE2b-256 checksum How to use checksums |
2e45f7d7557c2b4ff3d273bf68e4c3ced4b20449f90997ab8e66aa735bf360c0
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
python-requests/2.28.2
|
Security for aioduckdb 0.1.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
