Skip to main content

pymysql-based database connection pool

Project description

PyMySQLPool

build status codecov pip version license

PyMySQLPool is a pymysql-based database connection pool, simple and lightweight.

Table of content

Features

  • Maintain a minimum number of connection pools by default.
  • If a number of unuse connections less than zero, dynamically add connections to pool until the current number of inuse connections equal maximum of the pool.
  • Release the idle connections in regular until a number of unuse connections equal minimum of the pool.
  • Support auto-commit mode.
  • Support for ping check to get healthy connections.

Requirements

  • Python
    • CPython : >= 3.4
  • MySQL Server -- one of the following:
    • MySQL >= 5.5
    • MariaDB >= 5.5
  • PyMySQL: >= 0.9.2

Installation

Package is uploaded on PyPI

You can install with pip

$ pip install pymysql-pooling

Example

Make use of a simple table (Example in MySQL doc)

mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
    -> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

mysql> INSERT INTO pet
    -> VALUES ("Puffball", "Diane", "hamster", "f", "1999-03-30", NULL);
from pymysqlpool.pool import Pool


pool = Pool(host=HOST, port=PORT, user=USER, password=PASSWORD, db=DB)
pool.init()

connection = pool.get_conn()
cur = connection.cursor()
cur.execute('SELECT * FROM `pet` WHERE `name`=%s', args=("Puffball", ))
print(cur.fetchone())

pool.release(connection)

This example will print:

('Puffball', 'Diane', 'hamster', 'f', datetime.date(1999, 3, 30), None)

Support autocommit mode, as following:

pool = Pool(host=HOST, port=PORT, user=USER, password=PASSWORD, db=DB, autocommit=True)

That's all.

Roadmap

  • Connection Pool
  • Dynamically Create
  • Dynamically Release
  • Monitor Web Interface

Resources

License

PyMySQLPool is released under the MIT License. See LICENSE for more information.

Contributing

Thank you for your interest in the contribution of PyMySQLPool, your help and contribution is very valuable.

You can submit an issue and pull requests, please submit an issue before submitting pull requests.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pymysql-pooling-1.0.6.tar.gz (5.3 kB view details)

Uploaded Source

Built Distribution

pymysql_pooling-1.0.6-py3-none-any.whl (6.9 kB view details)

Uploaded Python 3

File details

Details for the file pymysql-pooling-1.0.6.tar.gz.

File metadata

  • Download URL: pymysql-pooling-1.0.6.tar.gz
  • Upload date:
  • Size: 5.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.21.0 setuptools/40.8.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/3.7.0

File hashes

Hashes for pymysql-pooling-1.0.6.tar.gz
Algorithm Hash digest
SHA256 afa349fd53fbd93ac68103c07f8e641815576c780011743803f890df560b827f
MD5 5a8decbcdd13c7eee5ff53780db81349
BLAKE2b-256 17bdb1ac40913ce80995aaf50b481b35ac769cf25191c89485f67c52efdfc8df

See more details on using hashes here.

File details

Details for the file pymysql_pooling-1.0.6-py3-none-any.whl.

File metadata

  • Download URL: pymysql_pooling-1.0.6-py3-none-any.whl
  • Upload date:
  • Size: 6.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.21.0 setuptools/40.8.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/3.7.0

File hashes

Hashes for pymysql_pooling-1.0.6-py3-none-any.whl
Algorithm Hash digest
SHA256 5a2c557498caaaae19a3cf88db1a4c439abb14d1b0750b2182d3b44b44bec499
MD5 ff57e0134829071ee8cfed2281fc83dd
BLAKE2b-256 60dd131be42f00c8148c96feac053456a3e43aa804fe07bd11fb6bf22d52a8af

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page