{"library":"pymysql-pool","title":"PyMySQL Pool","description":"PyMySQL Pool is a high-performance MySQL connection pool built on top of PyMySQL, supporting connection reuse, configurable pool limits, connection lifetime management, and automatic rollback/re-autocommit on return. Version 0.5.0 (stable) supports Python >=3.7, last release 2022-06.","language":"python","status":"active","last_verified":"Sat May 09","install":{"commands":["pip install pymysql-pool"],"cli":null},"imports":["from pymysqlpool import ConnectionPool","from pymysqlpool import PooledConnection"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"from pymysqlpool import ConnectionPool\n\npool = ConnectionPool(\n    host='localhost',\n    user='root',\n    password=os.environ.get('MYSQL_PWD', ''),\n    database='test',\n    maxsize=10,\n    pre_create_num=2,\n    pool_name='mypool'\n)\nconn = pool.get_conn()\ncursor = conn.cursor()\ncursor.execute('SELECT 1')\nresult = cursor.fetchone()\ncursor.close()\npool.release(conn)\nprint(result)","lang":"python","description":"Create a pool, borrow a connection via get_conn(), use it, then release it back.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}