I am currently working on a multi-tenancy project. Our team has decided that each tenant will have its own database, and the structure of the tables in each database will be the same across all tenants. However, we are facing a challenge in managing the connections to each tenant’s database. Should we connect to all tenants’ databases and leave the Sequelize connections open? I am seeking a solution to efficiently manage this aspect of the project.
I hope i can find a good and easy solution to implement this