I’m building a SaaS with multiple tenants and struggling to find the right balance between:

isolation scalability simplicity

Options I’m considering:

single DB, shared schema separate schemas per tenant fully isolated environments

For those who’ve done this in production, what approach worked best and why??