Connection pool¶
quma provides a connection pool implementation (PostgreSQL and MySQL only) similar to sqlalchemy’s and even borrows code and ideas from it.
Setup a pool:
# PostgreSQL pool (keeps 5 connections open and allows 10 more)
db = Database('postgresql+pool://username:password@/db_name', sqldir,
size=5, overflow=10)
# MySQL/MariaDB pool
db = Database('mysql+pool://username:password@/db_name', sqldir,
size=5, overflow=10)
For a description of the parameters see Connecting.