Should PostgreSQL connections be pooled in a Python web app, or create a new connection per request?
I think connection pooling is the best thing to do if this application is to serve multiple clients and concurrently.
I'm building a web app in Python (using Flask). I do not intend to use SQLAlchemy or similar ORM system, rather I'm going to use Psycopg2 directly.
Should I open a new database connection (and subsequently close it) for each new request? Or should I use something to pool these connections?