Viktar Patotski ·
· Architecture
· 6 min read Row-Level Security is one layer, not the whole answer. Real tenant isolation is defense in depth across the data, the API, and the keys, so that no single mistake exposes another customer. Here are the layers and where each one earns its place.
Viktar Patotski ·
· Architecture
· 8 min read Row-Level Security moves tenant isolation out of every developer's memory and into the database itself. Here is the exact Postgres pattern for a pooled multi-tenant app, plus the four footguns that leak data in production if you miss them.
Viktar Patotski ·
· Architecture
· 8 min read Silo, pool, or bridge is one of the few architecture choices you cannot cheaply reverse. Here are the three models in plain terms, how they map to a real database, and a decision framework so you pick the one your customers and your margins actually need.
Viktar Patotski ·
· Databases
· 11 min read Most database optimization guides hand you a list of ten techniques and skip the one question that matters: which problem do you actually have? Here is the diagnosis-first version. Find the real bottleneck, then apply the cheapest fix that clears it.
Viktar Patotski ·
· Databases
· 14 min read Most teams reach for sharding years before they need it. There is a ladder of cheaper, lower-risk fixes that comes first, and the right rung depends on which bottleneck you actually have: read load, write load, or data size. Here is the ladder, from cheapest to last resort.
Viktar Patotski ·
· Architecture
· 22 min read Both are excellent databases and for most SaaS workloads either one is fine. The honest answer: pick Postgres for greenfield, keep what you run well, and switch only for a reason you can name. Here are the few differences that actually decide it.