Show HN: Underrated Postgres: Build Multi-Tenancy with Row-Level Security

6 pointsposted 7 hours ago
by noctarius

4 Comments

pwlm

7 hours ago

From Postgres docs https://www.postgresql.org/docs/current/ddl-rowsecurity.html

I built multi-tenant services and never used RLS because it's complicated.

noctarius

7 hours ago

It is complicated to initially wrap your head around, I agree. That's why I thought a demo application is the best way to show that it doesn't have to be super complicated once understood.

Like many things in PG, they aren't always easy to get right away I remember my first time with it years and years ago.

MohanYC

7 hours ago

Great share!

noctarius

7 hours ago

Thank you very much :)

Happy to get any idea on how to make it even better!