Here i am working based on Multi-Tenant Architecture. so every client organisations need to have their own Databases and they are relational. so, in my case i need to work with " 'n' no of databases ".to solve my case i need to establish the database connection dynamically based on the every user request to their individual DB and need to perform CRUD operations (Note : concurrent operations need to perform on their own db without disturb others).
- which relational database and query interface is suitable for my case to use with Nodejs?
- any NPM plugins are available for migrations and seeding(Note : migrations and seeding are also need to be dynamic connection to database based on my assumption if new migration is arrived the connection is need to established to all databases in forloop one by one and migrations and seeding are need to run individually)?