Back to Blog
Engineering & SecurityNovember 12, 2026 5 min read

Why We Built Cafoor with Database-Per-Tenant Isolation

A look inside our multi-tenant architecture and why physical database isolation beats shared-table tenant_id filters for financial records.

Cafoor Engineering
Key Takeaway

Giving every company its own physical database eliminates an entire class of cross-tenant bugs and unlocks instant, per-customer backup and restore.

The Hidden Risk of Shared Financial Tables

Most SaaS ERPs store thousands of companies inside shared SQL tables separated only by a tenant_id column. One missing WHERE clause in a custom report can expose sensitive financial data.

How Cafoor Isolates Every Workspace

Each workspace owns its dedicated database file and upload directory under its subdomain. Unknown or suspended hostnames fail closed before any query runs.

Zero-Downtime Portability

Physical isolation also means restoring a single tenant takes seconds without touching anyone else, and customers can download their exact database snapshot whenever they want.

Ready to put these workflows into practice?

Launch your free Cafoor workspace and experience fast, connected financial operations.

Create Your Workspace