Session overview
A 55-minute whiteboard session walking through the architectural patterns we use to build production multi-tenant SaaS platforms. Includes detailed coverage of the three isolation models and the hybrid pattern we typically end up shipping.
What we cover
- The three isolation models. Shared schema, schema-per-tenant, database-per-tenant. Strengths, weaknesses, when to pick each.
- Row-Level Security in Postgres. How to implement it correctly, common pitfalls, connection pooling implications.
- The hybrid model. Shared infrastructure for small tenants, dedicated databases for enterprise. Routing, observability, and migration paths.
- Identity and tenant membership. Multi-tenant user accounts, SSO patterns, authorisation models.
- Background jobs and tenant context. How to propagate tenant context through async work.
- Observability per tenant. Tagging, dashboards, and per-tenant debugging.
Live diagrams
The session includes:
- Whiteboard walkthrough of the request lifecycle in a multi-tenant system.
- SQL examples showing how RLS policies are structured.
- Connection pooling diagrams for shared and dedicated database models.
- Migration path diagrams for moving tenants between isolation models.
Reference materials
The patterns shown in the session are documented in detail in our multi-tenant SaaS architecture guide and our reference architecture whitepaper.
Recording
Contact us to request the recording or schedule a private deep-dive session with our team.