I have a client that wants me to build a SaaS application with a multi-tenant architecture, where different clients will go in a separate schema on the same db server. I have seen this architecture before, but never really used it, so I am quite new to the concept.I am strongly against this as I think it would add a level of complexity to the app. Their biggest concern is security.The only security improvement that I can see from using this is protecting the users from developer mistakes:SQL injectionsInvalid or missing customer filters on the SQL queries.Both of these concerns are handled pretty well by modern development frameworks (I plan to use Django). Besides this, I can't really see any advantage.
What are the advantages of using multi-tenant architecture with separate db schemas per customer?
design patterns;architecture;multitenancy