Using SQLAlchemy to query a PostgreSQL database behind PgBouncer, using transaction-level pooling.
What is the best pattern to use for this kind of set up? Should I have one-engine-per-process, using a
ConnectionPool, or should I create an engine per-request, and use
NullPool for each one of them? Is there a different pattern altogether that I should be using?
Thanks very much! Let me know if more information is needed and I'll update ASAP.