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

  • <input type="checkbox" checked="" disabled="" /> Connection Pool
  • <input type="checkbox" checked="" disabled="" /> Dynamically Create
  • <input type="checkbox" checked="" disabled="" /> Dynamically Release
  • <input type="checkbox" disabled="" /> 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.

Files for pymysql-pooling, version 1.0.6
Filename, size File type Python version Upload date Hashes
Filename, size pymysql_pooling-1.0.6-py3-none-any.whl (6.9 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size pymysql-pooling-1.0.6.tar.gz (5.3 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page