pysolmysql
Welcome to pysol
Copyright (C) 2013/2025 Laurent Labatut / Laurent Champagnac
pysolmysql is a set of simple MYSQL client Apis
They are gevent based. They rely on pymysql.
Usage
d_conf = {
"host": "localhost",
"port": 3306,
"database": None,
"user": "root",
"password": "root",
"autocommit": True,
}
ar = MysqlApi.exec_n(d_conf, "select user, host from mysql.user;")
for d_record in ar:
logger.info("user=%s, host=%s", d_record["user"], d_record["host"])
Pool
Now backed by a basic pool implementation, which support underlying backend clusters (mariadb galera for instance)
This basic pool implementation is forked and adapted from :
- https://github.com/laurentL/django-mysql-geventpool-27
- https://github.com/shunsukeaihara/django-mysql-geventpool
Pool max size
Pool max size (default 10) can be specified using
d_conf = {
"pool_max_size": 10,
...
}
Possible backward compatibility issue:
- If the pool is maxed, an exception will be raised
Multiple hosts
Multiple hosts can be addressed in an active/active manner.
Several hosts can be specified using :
- "hosts" list (preferred)
d_conf = {
"hosts": ["localhost", "127.0.0.1"],
...
}
- "host" comma separated list
d_conf = {
"host": "localhost,127.0.0.1",
...
}
- "host" single entry (backward compatible mode)
d_conf = {
"host": "localhost",
...
}
1 maintainer
Metadata
1 maintainer
Release files for pysolmysql 3.13.5
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| pysolmysql-3.13.5.tar.gz | 20.7 kB | Details |
Release files / pysolmysql-3.13.5.tar.gz
| Download URL | pysolmysql-3.13.5.tar.gz |
|---|---|
| Size | 20.7 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
9fa0f880a5e339290f4994c83a0b279e40e59f0c597e93010db4c227bd4dc1d7
|
|
BLAKE2b-256 checksum How to use checksums |
c26144ac0b32c2abe336d5208cd634337864ac7ec305e3c51fc0a9dc397ed796
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.13.5
|
