Technical Glossary
Multi-tenant Architecture
Exact Definition
Multi-tenant architecture is a software architecture pattern where a single physical instance of an application serves multiple distinct client organizations (tenants), while ensuring complete logical separation of user profiles and data.
Architectural Deep Dive
Multi-tenant architectures allow a single codebase and application server to serve multiple client organizations (tenants). In a multi-tenant system, tenants share compute infrastructure, but their data is isolated. This isolation is typically implemented in one of three ways: database-per-tenant, schema-per-tenant, or shared database with column-level isolation.
The ERPStack Approach
We implement Schema-per-Tenant and Database-per-Tenant isolation patterns using Drizzle ORM and PostgreSQL. This guarantees complete data isolation for corporate clients while maintaining the scaling benefits of a shared codebase.