Most multi-tenant applications keep tenants apart with one line of code, repeated forever: SELECT...
Most multi-tenant applications keep tenants apart with one line of code,
repeated forever:
SELECT * FROM documents WHERE organization_id = $1
Enter fullscreen mode
Exit fullscreen mode
Skip the ORM magic and implement true RLS policies with SQLAlchemy to isolate tenant data at the database layer, not the…
Ten days ago I wrote that the Postgres role which runs your migrations bypasses every row-level...
Deep dive into how RLS policies interact with the PostgreSQL query planner — covering policy inlining, why naive RLS destroys…
Startups building B2B products reach for multi-tenancy in PostgreSQL the same way on day one: one...
Most backend engineers implement multi-tenant quota checks using a standard "read-then-write"...
A wrong RLS policy doesn't throw an error, it just returns the wrong rows, so it ships untested and...
