How to build efficient Database architecture
What is the best approach for the database design for the applications ,i will be building for my future SaaS business.
There are many SaaS agencies ,how they handle database, does they create database for every client or follows Multitenant architecture or something else.
Seperete db for every client is not an option for me
Different schema for every services but a single schema for every tenant having same shared database, i dont know if this is flexible or not.
And seperate db for every microservice ,idk it would be complex
I wanna build a scalable ,flexible architecture for just 100-500 clients, and the services I provide will be similar but the schema can change according to clients.
And I dont have that much knowledge about the Database architecture.
Any suggestions about efficient way to design db, tools and tech will help me a lot
Thank you.