Writing/Series
Drafting Table
Building a multi-tenant platform where every customer designs their own database — the entity platform.
All parts
5 posts- Intro Building a platform where customers design their own database Why we're building a 'define-your-own-data' platform — and what this series will cover.
- Part 1 One engine, many schemas The core bet: a registry as source of truth, JSON for storage, and generated SQL views on top.
- Part 2 Keeping tenants apart with Row-Level Security How Postgres makes data isolation a property of the database — and the view gotcha that nearly leaked everything.
- Part 3 Unique keys and foreign keys… on JSON How to enforce real constraints and relationships when the data lives in a JSON blob and the schema was invented by a user.
- Part 4 What a load test taught us A bottleneck we couldn't see, a 400ms query that became 0.3ms, and why 'a lot of data' isn't the same as 'slow.'