Skip to content

This Python package provides a robust solution for managing MySQL connections in multi-threaded applications. It implements an auto-scaling connection pool that grows and shrinks based on demand, ensuring efficient resource use and eliminating the hassle of manually creating and deleting connections.

Notifications You must be signed in to change notification settings

BhaskarPanja93/pooledMySQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 

Repository files navigation

pooledMySQL v4.0.2

pip install pooledMySQL --upgrade


A well maintained program to have MySQL connection pool which auto-scales infinitely as required. This would help remove problems caused by multithreading, also removed user hassle of manually creating and deleting connections manually.


To install:

pip install pooledMySQL --upgrade
pip3 install pooledMySQL --upgrade
python -m pip install pooledMySQL --upgrade
python3 -m pip install pooledMySQL --upgrade



Using this program is as simple as:

from pooledMySQL import Manager as MySQLManager

executorMySQL = MySQLManager("SomeUsername", "SomePassword", "DatabaseName")

listOfDict = executorMySQL.execute("SELECT * from someTable where someColumn = ?", ["someValue"])

for individualDict in listOfDict:
    print(individualDict)


Future implementations:

  • Classes for individual tables to make reading and writing of rows way easier for the user
  • Table and database creation syntaxes

This project is always open to suggestions and feature requests.

About

This Python package provides a robust solution for managing MySQL connections in multi-threaded applications. It implements an auto-scaling connection pool that grows and shrinks based on demand, ensuring efficient resource use and eliminating the hassle of manually creating and deleting connections.

Topics

Resources

Stars

Watchers

Forks

Languages