asyncmy - A fast asyncio MySQL driver
Introduction
asyncmy is a fast asyncio MySQL driver, which reuse most of pymysql and rewrite
core with cython to speedup.
Features
Benchmark
The result comes from benchmark, we can know asyncmy performs well when compared to other drivers.
The device is MacBook Pro (13-inch, M1, 2020) 16G and MySQL version is 8.0.23.
Install
Just install from pypi:
> pip install asyncmy
Usage
Use connect
from asyncmy import connect
from asyncmy.cursors import DictCursor
import asyncio
async def run():
conn = await connect()
async with conn.cursor(cursor=DictCursor) as cursor:
await cursor.execute("create database if not exists test")
await cursor.execute(
"""CREATE TABLE if not exists test.asyncmy
(
`id` int primary key auto_increment,
`decimal` decimal(10, 2),
`date` date,
`datetime` datetime,
`float` float,
`string` varchar(200),
`tinyint` tinyint
)"""
)
if __name__ == '__main__':
asyncio.run(run())
Use pool
import asyncmy
import asyncio
async def run():
pool = await asyncmy.create_pool()
async with pool.acquire() as conn:
async with conn.cursor() as cursor:
await cursor.execute("SELECT 1")
ret = await cursor.fetchone()
assert ret == (1,)
if __name__ == '__main__':
asyncio.run(run())
Replication
from asyncmy import connect
from asyncmy.replication import BinLogStream
import asyncio
async def run():
conn = await connect()
ctl_conn = await connect()
stream = BinLogStream(
conn,
ctl_conn,
1,
master_log_file="binlog.000172",
master_log_position=2235312,
resume_stream=True,
blocking=True,
)
await stream.connect()
async for event in stream:
print(event)
if __name__ == '__main__':
asyncio.run(run())
ThanksTo
asyncmy is build on top of these nice projects.
- pymysql, a pure python MySQL client.
- aiomysql, a library for accessing a MySQL database from the asyncio.
- python-mysql-replication, pure Python Implementation of MySQL replication protocol build on top of PyMYSQL.
License
This project is licensed under the Apache-2.0 License.
1 maintainer
Metadata
1 maintainer
Release files for asyncmy 0.1.4
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| asyncmy-0.1.4.tar.gz | 60.1 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| asyncmy-0.1.4-cp39-cp39-manylinux2014_x86_64.whl | CPython 3.9 | CPython 3.9 | Linux glibc 2.17+ x86-64 | Details |
Total release size: 3.2 MB
Release files / asyncmy-0.1.4.tar.gz
| Download URL | asyncmy-0.1.4.tar.gz |
|---|---|
| Size | 60.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
6ffa379555b4f40f6cf1d8324ffb1b456c901942d924bd14db373c30f3a54e09
|
|
BLAKE2b-256 checksum How to use checksums |
636ed988171176fe61333199e821d20d13f821b5c994b9a99d4e67fcb21bab76
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.4.1 importlib_metadata/3.7.3 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.9.2
|
Release files / asyncmy-0.1.4-cp39-cp39-manylinux2014_x86_64.whl
| Download URL | asyncmy-0.1.4-cp39-cp39-manylinux2014_x86_64.whl |
|---|---|
| Size | 3.1 MB |
| Tags | CPython 3.9 Linux glibc 2.17+ x86-64 |
|
SHA-256 checksum How to use checksums |
1934a7aab8dd3e944b031cbfbea1e2e3bcedea00783b20d3060501ef71547cec
|
|
BLAKE2b-256 checksum How to use checksums |
f65325decc040e226746886cccd147cbdd81a3346db6f7c2c4b00073e295d785
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.4.1 importlib_metadata/3.7.3 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.9.2
|
