Database isolation model
The choice between shared schema with row-level security, separate schemas per tenant, and separate databases per tenant involves trade-offs in cost, isolation strength, query complexity, and migration difficulty. The wrong choice for a product's customer profile and compliance requirements creates problems at a point when changing it is maximally disruptive.
