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

https://www.simplyblock.io/blog/underated-postgres-multi-tenancy-with-row-level-security/

6•noctarius•1h ago

Utilizing Postgres' RLS feature to isolate user data instead of easy-to-forget where-clauses, is such an underrated use case, I really wonder why not more people use it.

If you prefer code over the blog post, I've put the full application example on GitHub. Would love to hear your thoughts.

https://github.com/simplyblock/example-rls-invoicing

Comments

pwlm•1h 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•1h 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•1h ago

Great share!

noctarius•1h ago

Thank you very much :)

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

Show HN: XPlant – Track, optimize and iterate your plants like code

Signy: Signed URLs for Small Devices

The Billionaire Trump Supporter Who Will Soon Own the News

RISC-V Needs Secure 'Wheels': The MCU Initiator-Side Perspective

Arch Linux AUR package repository is being DDoSed

Nvidia to Invest $5B in Intel

Whose Punctuation Is More Human: Yours or A.I.'S?

Why the Events in Gaza Are Not "Genocide"

Literate Programming

What is the recipe for human progress?

Proprietary sector indexes across tech and beyond

Mirror Life Worries

The Challenges of Distributed Systems

American Chemical Society: do not expect CO2 capture breakthrough to save us

Kmart broke privacy laws by using facial recognition, commissioner finds

RDMA-Powered Distributed Cache for Fast AI Training and Inference

The Constexpr Debugger

Unbundling Adobe

China's largest chipmaker testing first homegrown immersion DUV litho tool

Nvidia buys $5B in Intel stock in seismic deal

JLR hack: Supply chain staff told to apply for Universal Credit, claims union

Toys can tell us a lot about the future of tech

South Africa's Small Businesses Are Overtaxed. Its Gotten Out of Hand [video]

Translating ePub Ebooks with Local LLM and for Free. An Effective Approach

The Hottest New Defense Against Drones? Lasers

Samsung brings ads to US fridges

Garys Economics: What does Elon Musk want? [video]

Toyota Exec Thinks Hydrogen 'Will Take over Diesel'

AI Product Image Generator – Create Product Photos

China bans tech companies from buying Nvidia's AI chips