I have a Rails app that makes connections to other DBs. There may be multiple users connecting to multiple DBs.
The app makes a database connection as part of an action. However, I noticed a problem: there’s too many DB connections remaining open, which is causing the DB to not have enough connections remaining for new connections.
So the answer is using a shared connection pool. Importantly, the connection pool needs to be shared amongst different actions / HTTP requests.
Is there any middleware that extends Sequel’s or ActiveRecord’s connection pool to do this? (Or some code that someone can suggest to do this?)