معرفی شرکت ها
asyncdb-2.1.9
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشتر
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشتر
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشتر
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشتر
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشترتوضیحات
Library for Asynchronous data source connections Collection of asyncio drivers.
| ویژگی | مقدار |
|---|---|
| سیستم عامل | POSIX :: Linux |
| نام فایل | asyncdb-2.1.9 |
| نام | asyncdb |
| نسخه کتابخانه | 2.1.9 |
| نگهدارنده | [] |
| ایمیل نگهدارنده | [] |
| نویسنده | Jesus Lara |
| ایمیل نویسنده | jesuslarag@gmail.com |
| آدرس صفحه اصلی | https://github.com/phenobarbital/asyncdb |
| آدرس اینترنتی | https://pypi.org/project/asyncdb/ |
| مجوز | BSD |
# AsyncDB #
AsyncDB is a collection of different Database Drivers using asyncio-based connections, 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 a subset of drivers (connectors) for accessing different databases and data sources for data interaction.
The main goal of AsyncDB is using asyncio-based technologies.
### Getting Started ###
## Requirements
Python 3.8+
## Installation
<div class="termy">
```console
$ pip install asyncdb
---> 100%
Successfully installed asyncdb
```
Can also install only drivers required like:
```console
$ pip install asyncdb[pg] # this install only asyncpg
```
Or install all supported drivers as:
```console
$ 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 (requires aiomcache)
* MS SQL Server (non-asyncio using freeTDS and pymssql)
* Apache Cassandra (requires official cassandra driver)
* InfluxDB (using influxdb)
* CouchBase (using aiocouch)
* MongoDB (using motor)
* SQLAlchemy (requires sqlalchemy async (+3.14))
### Quick Tutorial ###
```python
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: aioredis (Redis)
* mcache: aiomcache (Memcache)
* odbc: aiodbc (ODBC)
#### Future work: ####
* Prometheus
### Output Support ###
With Output Support results can be returned into a wide-range of variants:
```python
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.
نیازمندی
| مقدار | نام |
|---|---|
| ==0.37.1 | wheel |
| ==0.29.32 | Cython |
| ==1.23.4 | numpy |
| ==38.0.2 | cryptography |
| ==3.8.3 | aiohttp |
| ==0.26.0 | asyncpg |
| ==0.17.0 | uvloop |
| ==3.4.3 | asyncio |
| ==2.1.7 | cchardet |
| ==1.5.0 | pandas |
| ==2.0.1 | xlrd |
| ==3.0.10 | openpyxl |
| ==4.0.2 | lz4 |
| ==4.4.0 | typing-extensions |
| ==1.26.12 | urllib3 |
| >=2.0.7 | charset-normalizer |
| ==2.2.0 | ciso8601 |
| ==1.1.0 | iso8601 |
| ==0.5.4 | pgpy |
| ==0.4.27 | python-magic |
| ==1.1.1 | dateparser |
| >=0.0.37 | python-datamodel |
| ==2022.9.1 | dask |
| ==1.0.0 | datatable |
| ==0.14.19 | polars |
| ==4.0.1 | pyarrow |
| ==0.3.0 | connectorx |
| >=0.15.0 | aiosqlite |
| ==1.6.3 | pylibmc |
| ==0.7.0 | aiomcache |
| ==1.4.0 | jsonpath-rw |
| ==1.2.2 | jsonpath-rw-ext |
| ==4.3.4 | redis |
| ==2.0.1 | aioredis |
| ==2.0.0 | hiredis |
| ==0.6.1 | objectpath |
| ==0.26.0 | asyncpg |
| ==2.4.9 | rethinkdb |
| ==1.3.5 | aiopg |
| >=2.9.1 | psycopg2-binary |
| ==1.27.91 | botocore |
| ==1.24.91 | boto3 |
| ==3.25.0 | cassandra-driver |
| ==5.3.1 | influxdb |
| ==1.33.0 | influxdb-client |
| ==0.3.3 | aioodbc |
| ==1.2.3 | JayDeBeApi |
| ==4.0.34 | pyodbc |
| ==1.4.42 | sqlalchemy |
| ==8.4.3 | elasticsearch[async] |
| ==4.2.0 | pymongo |
| ==3.0.0 | motor |
| ==2.2.5 | pymssql |
| ==4.0.5 | couchbase |
| ==2.2.2 | aiocouch |
| ==0.2.5 | asyncmy |
| ==2.1.1 | mysqlclient |
| ==5.1 | hazelcast-python-client |
| ==0.1.1 | aiomysql |
| ==3.3.0 | pyspark |
| ==1.1.1 | oracledb |
| ==1.27.59 | botocore |
| ==2.4.0 | aiobotocore |
| ==1.27.59 | botocore |
| ==1.24.91 | boto3 |
| ==2.4.0 | aiobotocore |
| ==3.25.0 | cassandra-driver |
| ==4.0.5 | couchbase |
| ==2.2.2 | aiocouch |
| ==2022.9.1 | dask |
| ==1.0.0 | datatable |
| ==0.14.19 | polars |
| ==4.0.1 | pyarrow |
| ==0.3.0 | connectorx |
| ==3.3.0 | pyspark |
| ==2.0.1 | aioredis |
| ==1.6.3 | pylibmc |
| ==0.7.0 | aiomcache |
| >=0.15.0 | aiosqlite |
| ==3.25.0 | cassandra-driver |
| ==2.4.9 | rethinkdb |
| ==5.3.1 | influxdb |
| ==1.33.0 | influxdb-client |
| ==2.2.5 | pymssql |
| ==7.15.1 | elasticsearch[async] |
| ==5.1 | hazelcast-python-client |
| ==5.3.1 | influxdb |
| ==1.33.0 | influxdb-client |
| ==1.2.3 | JayDeBeApi |
| ==0.1.1 | aiomysql |
| ==1.6.3 | pylibmc |
| ==0.7.0 | aiomcache |
| ==4.2.0 | pymongo |
| ==3.0.0 | motor |
| ==2.2.5 | pymssql |
| ==0.2.5 | asyncmy |
| ==2.1.1 | mysqlclient |
| ==0.3.3 | aioodbc |
| ==4.0.34 | pyodbc |
| ==1.1.1 | oracledb |
| ==1.3.5 | aiopg |
| >=2.9.1 | psycopg2-binary |
| ==0.26.0 | asyncpg |
| ==3.3.0 | pyspark |
| ==1.4.0 | jsonpath-rw |
| ==1.2.2 | jsonpath-rw-ext |
| ==4.3.4 | redis |
| ==2.0.1 | aioredis |
| ==2.0.0 | hiredis |
| ==0.6.1 | objectpath |
| ==2.4.9 | rethinkdb |
| ==1.4.42 | sqlalchemy |
| >=0.15.0 | aiosqlite |
زبان مورد نیاز
| مقدار | نام |
|---|---|
| >=3.8.0 | Python |
نحوه نصب
نصب پکیج whl asyncdb-2.1.9:
pip install asyncdb-2.1.9.whl
نصب پکیج tar.gz asyncdb-2.1.9:
pip install asyncdb-2.1.9.tar.gz