DEV Community

Discussion on: Flask and SQLAlchemy without the Flask-SQLAlchemy Extension

Collapse
 
sonnk profile image
Nguyen Kim Son

Thanks for the information! We used to ran into the problem of the connection being killed before (I suspected this is the database killing inactive connections but this should be already handled by the connection pool) and the workaround is to create a new connection every time, even if it adds overhead.

Thread Thread
 
gary_vandermerwe_2832fd profile image
Gary van der Merwe

A better option is to set the pool_recycle arg when you create the engine. That will get the pool to close any connections that are unused after a period of time.