Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I am about to start a SaaS application for companies (clients of the app) to mange their employees, customers. Application would have different roles in it such as admin, manager etc.
Do you use separate db for each client or single db for every client in such project? What database would be suitable for that?
Do this: go to the Sales department and ask :
If the reply is YES you have Customers, therefore you have to go single tenant and dedicate one database per customer.
If you cannot name your customers because your application has a number of users that come and go… and they can create their own account with an e-mail and they are in... you don't have customers, you have users, therefore use multi tenant.
