AsyncDB
AsyncDB is a collection of different Database Drivers using asyncio-based connections and binary connectors (as asyncpg) but providing an abstraction layer to easily connect to different data sources, a high-level abstraction layer for various non-blocking database connectors, on other blocking connectors (like MS SQL Server) we are using ThreadPoolExecutors to run in a non-blocking manner.
Why AsyncDB?
The finality of AsyncDB is to provide us with a subset of drivers (connectors) for accessing different databases and data sources for data interaction. The main goal of AsyncDB is to use asyncio-based technologies.
Getting Started
Requirements
Python 3.9+
Installation
$ pip install asyncdb
---> 100%
Successfully installed asyncdb
Can also install only drivers required like:
$ pip install asyncdb[pg] # this install only asyncpg
Or install all supported drivers as:
$ pip install asyncdb[all]
Requirements
- Python >= 3.8
- asyncio (https://pypi.python.org/pypi/asyncio/)
Currently AsyncDB supports the following databases:
- PostgreSQL (supporting two different connectors: asyncpg or aiopg)
- SQLite (requires aiosqlite)
- mySQL/MariaDB (requires aiomysql and mysqlclient)
- ODBC (using aioodbc)
- JDBC(using JayDeBeApi and JPype)
- RethinkDB (requires rethinkdb)
- Redis (requires aioredis)
- Memcache (optional, requires aiomcache:
pip install asyncdb[memcache]) - MS SQL Server (non-asyncio using freeTDS and pymssql)
- Apache Cassandra (requires official cassandra driver)
- InfluxDB (using influxdb)
- CouchBase (using aiocouch)
- MongoDB (using motor and pymongo)
- SQLAlchemy (requires sqlalchemy async (+3.14))
- Oracle (requires oracledb)
- Redpanda (Kafka-compatible, requires aiokafka)
Platform Support
AsyncDB's core package (pip install asyncdb) and the default extra
(pip install asyncdb[default]) are supported on Linux, macOS, and Windows
for Python 3.10–3.14. uvloop remains an optional performance extra
(pip install asyncdb[uvloop]): it is only available on POSIX platforms and
is never required to import or run AsyncDB. On Windows, uvloop activation
is automatically and safely skipped, and the standard asyncio event loop
policy is used instead.
The default extra covers SQLite (aiosqlite), RethinkDB, InfluxDB, Redis,
MS SQL Server (pymssql), Delta Lake, and DuckDB, in addition to the
PostgreSQL support (asyncpg) that ships with the core package.
Other provider extras (Cassandra, ScyllaDB, MySQL/MySQLdb, ODBC, Oracle,
JDBC, ClickHouse, etc.) depend on native or platform-sensitive client
libraries and are not guaranteed to be installable or fully supported on
every platform, including Windows. Selecting a driver whose optional
dependency is not installed raises a focused error naming the provider and
the extra required to install it (e.g. pip install asyncdb[mysql]).
Quick Tutorial
from asyncdb import AsyncDB
db = AsyncDB('pg', dsn='postgres://user:password@localhost:5432/database')
# Or you can also passing a dictionary with parameters like:
params = {
"user": "user",
"password": "password",
"host": "localhost",
"port": "5432",
"database": "database",
"DEBUG": True,
}
db = AsyncDB('pg', params=params)
async with await db.connection() as conn:
result, error = await conn.query('SELECT * FROM test')
And that's it!, we are using the same methods on all drivers, maintaining a consistent interface between all of them, facilitating the re-use of the same code for different databases.
Every Driver has a simple name to call it:
- pg: AsyncPG (PostgreSQL)
- postgres: aiopg (PostgreSQL)
- mysql: aiomysql (mySQL)
- influx: influxdb (InfluxDB)
- redis: redis-py (Redis)
- memcache: aiomcache (Memcache, async, no system libraries required)
- odbc: aiodbc (ODBC)
- oracle: oracle (oracledb)
- redpanda: Redpanda/Kafka (aiokafka)
Output Support
With Output Support results can be returned into a wide-range of variants:
from datamodel import BaseModel
class Point(BaseModel):
col1: list
col2: list
col3: list
db = AsyncDB('pg', dsn='postgres://user:password@localhost:5432/database')
async with await d.connection() as conn:
# changing output format to Pandas:
conn.output_format('pandas') # change output format to pandas
result, error = await conn.query('SELECT * FROM test')
conn.output_format('csv') # change output format to CSV
result, _ = await conn.query('SELECT TEST')
conn.output_format('dataclass', model=Point) # change output format to Dataclass Model
result, _ = await conn.query('SELECT * FROM test')
Currently AsyncDB supports the following Output Formats:
- CSV (comma-separated or parametrized)
- JSON (using orjson)
- iterable (returns a generator)
- Recordset (Internal meta-Object for list of Records)
- Pandas (a pandas Dataframe)
- Datatable (Dt Dataframe)
- Dataclass (exporting data to a dataclass with -optionally- passing Dataclass instance)
- PySpark Dataframe
And others to come:
- Apache Arrow (using pyarrow)
- Polars (Using Python polars)
- Dask Dataframe
Contribution guidelines
Please have a look at the Contribution Guide
- Writing tests
- Code review
Who do I talk to?
- Repo owner or admin
- Other community or team contact
License
AsyncDB is copyright of Jesus Lara (https://phenobarbital.info) and is licensed under BSD. I am providing code in this repository under an open source licenses, remember, this is my personal repository; the license that you receive is from me and not from my employeer.
2 maintainers
Release files for asyncdb 2.16.2
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distributions (wheels)
Total release size: 6.9 MB
Release files / asyncdb-2.16.2-cp314-cp314-win_amd64.whl
| Download URL | asyncdb-2.16.2-cp314-cp314-win_amd64.whl |
|---|---|
| Size | 254.2 kB |
| Tags | CPython 3.14 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
300e58fd7107720cbeabb1dbe1891fa2f09265c65ff1a38fad19a88237544bad
|
|
BLAKE2b-256 checksum How to use checksums |
60543a4a3e2d8280e9e67cb8f661a21b9f6a8693ecff60ffa277630e2201af7d
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp314-cp314-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl
| Download URL | asyncdb-2.16.2-cp314-cp314-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl |
|---|---|
| Size | 591.4 kB |
| Tags | CPython 3.14 Linux glibc 2.28+ x86-64 Linux glibc 2.5+ x86-64 |
|
SHA-256 checksum How to use checksums |
191a1b7c79143764f8b404b81117c312d914b6e259eb2d6ce797cd8513b9e2bf
|
|
BLAKE2b-256 checksum How to use checksums |
14fc5abb5e81de9e82a790a61d76b1bccb0a8ffecf0db5a9b5d5728a5e207f01
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp314-cp314-macosx_11_0_arm64.whl
| Download URL | asyncdb-2.16.2-cp314-cp314-macosx_11_0_arm64.whl |
|---|---|
| Size | 266.4 kB |
| Tags | CPython 3.14 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
e848fe2a2bcd0f32cadb28f9df74fb2a9ad963440665adcd58f059601d6ea912
|
|
BLAKE2b-256 checksum How to use checksums |
1464170f691a98f6756f2e48a57ca197bbcd53525ed9579e77a3fd0823e77ed2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp314-cp314-macosx_10_15_x86_64.whl
| Download URL | asyncdb-2.16.2-cp314-cp314-macosx_10_15_x86_64.whl |
|---|---|
| Size | 267.5 kB |
| Tags | CPython 3.14 macOS 10.15+ x86-64 |
|
SHA-256 checksum How to use checksums |
71fedbc59cfef008ca35d3a3c51509066c6283e7ca54ac7f0bad848ab15f2bb0
|
|
BLAKE2b-256 checksum How to use checksums |
e95170a3ff61f449bb8be2ff3bed583459d73f41400747b5a15719b2a4e38978
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp313-cp313-win_amd64.whl
| Download URL | asyncdb-2.16.2-cp313-cp313-win_amd64.whl |
|---|---|
| Size | 254.2 kB |
| Tags | CPython 3.13 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
14443f474ba0704aff59e8955dd046f26131575e60a6c843f5c06b10d0ca03ec
|
|
BLAKE2b-256 checksum How to use checksums |
93cf75ceaef9ffc699858590cb1efbfbb5a5eaf1235f4f5106c724072a8f2395
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp313-cp313-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl
| Download URL | asyncdb-2.16.2-cp313-cp313-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl |
|---|---|
| Size | 594.1 kB |
| Tags | CPython 3.13 Linux glibc 2.28+ x86-64 Linux glibc 2.5+ x86-64 |
|
SHA-256 checksum How to use checksums |
48d396a61e66020698dfd6071347eb59ccf45809a8c331ab23ff51b2360a9d84
|
|
BLAKE2b-256 checksum How to use checksums |
e4d8aded740202e74929049cc28143512d68c1da6aebfd7f503bbd2f157a6cd1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp313-cp313-macosx_11_0_arm64.whl
| Download URL | asyncdb-2.16.2-cp313-cp313-macosx_11_0_arm64.whl |
|---|---|
| Size | 266.5 kB |
| Tags | CPython 3.13 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
affe8d0e8a674904cbcdc6c84fa373df3d593e2ebfc2eb1b25b6cd569b5fa3f3
|
|
BLAKE2b-256 checksum How to use checksums |
8dcc078879dc8323aa38ef8122e219be2e25d55b88a072cf811579a32cc1591e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp313-cp313-macosx_10_13_x86_64.whl
| Download URL | asyncdb-2.16.2-cp313-cp313-macosx_10_13_x86_64.whl |
|---|---|
| Size | 267.5 kB |
| Tags | CPython 3.13 macOS 10.13+ x86-64 |
|
SHA-256 checksum How to use checksums |
218b129f986ab9e3b7481baea809d92e3704c264ef3194b9f5470b3741bb5221
|
|
BLAKE2b-256 checksum How to use checksums |
9d0e4bfb30d4efe901b0c60aeea43a280ca7b341a46c28d7a00526737f6c98b4
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp312-cp312-win_amd64.whl
| Download URL | asyncdb-2.16.2-cp312-cp312-win_amd64.whl |
|---|---|
| Size | 254.4 kB |
| Tags | CPython 3.12 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
6c2d39c8e7a38b718f88302a5843daf386780a69c50a4c22516e49d827a8a189
|
|
BLAKE2b-256 checksum How to use checksums |
d29e20795a7997a4cbe769e94f4b04fe8f5c194876ba3baf897ab57ab8e522eb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp312-cp312-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl
| Download URL | asyncdb-2.16.2-cp312-cp312-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl |
|---|---|
| Size | 596.5 kB |
| Tags | CPython 3.12 Linux glibc 2.28+ x86-64 Linux glibc 2.5+ x86-64 |
|
SHA-256 checksum How to use checksums |
d57ee05e4005cbf4104aa0f6b0922d31164fcf9ad65909dc4c1f307716624409
|
|
BLAKE2b-256 checksum How to use checksums |
67bd1e518977ec205e7621c3cc80ad8108ac699b43812c734369bfe4ce4508fd
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp312-cp312-macosx_11_0_arm64.whl
| Download URL | asyncdb-2.16.2-cp312-cp312-macosx_11_0_arm64.whl |
|---|---|
| Size | 267.7 kB |
| Tags | CPython 3.12 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
eed545e8d4021e5e8b8dd5bd8e18ac367e2d1fb14a79fdc3b54dc9d1471a21e9
|
|
BLAKE2b-256 checksum How to use checksums |
238aa74cf4d3f627345f6d9f26c0a8f2bf2adf854fdf37812754de87e6987237
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp312-cp312-macosx_10_13_x86_64.whl
| Download URL | asyncdb-2.16.2-cp312-cp312-macosx_10_13_x86_64.whl |
|---|---|
| Size | 268.5 kB |
| Tags | CPython 3.12 macOS 10.13+ x86-64 |
|
SHA-256 checksum How to use checksums |
2368404c6449c60a6a626e6dd5f7b4ad2e72ce649204e219f6d2e1a52a22f3b0
|
|
BLAKE2b-256 checksum How to use checksums |
93aceb51e5940ba1e30d0a94fd8dbf800714b73d1d53916f45b84d29da5a8177
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp311-cp311-win_amd64.whl
| Download URL | asyncdb-2.16.2-cp311-cp311-win_amd64.whl |
|---|---|
| Size | 254.8 kB |
| Tags | CPython 3.11 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
18f767187a2314a453b34a531e9f87c8165ea1473301c6e229083117d72e9226
|
|
BLAKE2b-256 checksum How to use checksums |
2f8052251301df8cabe7d0406d5145cefa33dbfbe1a267c937d249c136674426
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp311-cp311-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl
| Download URL | asyncdb-2.16.2-cp311-cp311-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl |
|---|---|
| Size | 594.5 kB |
| Tags | CPython 3.11 Linux glibc 2.28+ x86-64 Linux glibc 2.5+ x86-64 |
|
SHA-256 checksum How to use checksums |
1060125f5f9656b092ff50116b28f8fa2221c8671d064bdd69d11249017cf3a5
|
|
BLAKE2b-256 checksum How to use checksums |
c322a959de7acf52e7142580b51ddae1e0ccdf5fe2cf7d2ddb10141060963323
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp311-cp311-macosx_11_0_arm64.whl
| Download URL | asyncdb-2.16.2-cp311-cp311-macosx_11_0_arm64.whl |
|---|---|
| Size | 266.2 kB |
| Tags | CPython 3.11 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
d9a99d7ed80d6b35cd307256cb8e9995eba22c65d68e4597793bfc48edf5e255
|
|
BLAKE2b-256 checksum How to use checksums |
14ceb4fa991fa45902063f06240eea1aa48979a2c272533d8142d929570f28cd
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp311-cp311-macosx_10_9_x86_64.whl
| Download URL | asyncdb-2.16.2-cp311-cp311-macosx_10_9_x86_64.whl |
|---|---|
| Size | 267.2 kB |
| Tags | CPython 3.11 macOS 10.9+ x86-64 |
|
SHA-256 checksum How to use checksums |
62c95b058317c760627404cffa7c7665938f7bbdb6bd4333d8119402b0cb1947
|
|
BLAKE2b-256 checksum How to use checksums |
4fdfdd52bc7c40851c2f779cbe327b706d47e3b1547e996a1998928c9d83ef1a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp310-cp310-win_amd64.whl
| Download URL | asyncdb-2.16.2-cp310-cp310-win_amd64.whl |
|---|---|
| Size | 254.3 kB |
| Tags | CPython 3.10 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
5bbf56fce94a2fd9afaa2c1a7677df7e6f293ed62ec8bb8c96aa8a3ba6fb86f5
|
|
BLAKE2b-256 checksum How to use checksums |
f007a94db0a573c406443149fa55d88e6760df274adab1fc1127d21e3596d287
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp310-cp310-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl
| Download URL | asyncdb-2.16.2-cp310-cp310-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl |
|---|---|
| Size | 559.3 kB |
| Tags | CPython 3.10 Linux glibc 2.28+ x86-64 Linux glibc 2.5+ x86-64 |
|
SHA-256 checksum How to use checksums |
e7882fc24f7765adab5339472d59f7cf49b1baa625fa70d7ede611e6448bf15e
|
|
BLAKE2b-256 checksum How to use checksums |
25c70f6ae894c4cd705bf05cee12994212ba61fb74df89a3b22e7c1906ad1b58
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp310-cp310-macosx_11_0_arm64.whl
| Download URL | asyncdb-2.16.2-cp310-cp310-macosx_11_0_arm64.whl |
|---|---|
| Size | 266.1 kB |
| Tags | CPython 3.10 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
3d1f062bbb9cce7121d82555f388e31052ed026d4b19f1c2bdfea20937bf3c94
|
|
BLAKE2b-256 checksum How to use checksums |
d976ab0a09cdf89ede88439d680bfec38e66a6fab5e59e33a76b19037e0171ca
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
Release files / asyncdb-2.16.2-cp310-cp310-macosx_10_9_x86_64.whl
| Download URL | asyncdb-2.16.2-cp310-cp310-macosx_10_9_x86_64.whl |
|---|---|
| Size | 267.1 kB |
| Tags | CPython 3.10 macOS 10.9+ x86-64 |
|
SHA-256 checksum How to use checksums |
70bafa8edf2897231091cdf2e21024147babf48188eb8bf5b82f719d0a0284b3
|
|
BLAKE2b-256 checksum How to use checksums |
eb189441d1883716aff16c41b721a87f0aebe5fe5761088c90d4714dfdabf38d
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.7
|
