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

6 noctarius 4 9/18/2025, 9:46:36 AM simplyblock.io ↗

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 (4)

pwlm · 48m 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 · 43m 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 · 45m ago

Great share!

noctarius · 42m ago

Thank you very much :)

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

Benchmarking Humans and AI in Contract Drafting (legalbenchmarks.ai)

Show HN: AI agents to handle customer support tickets (ticketdesk.ai)

Nexstar to Acquire Tegna for $6.2B in Local TV Megadeal Fueled by Deregulation (deadline.com)

Are Some People Addicted to Revenge? (nautil.us)

AI Pharmacist (drguide.net)

Jimmy Fallon Pitches His New Invention at Detroit's Newlab (2 Min Video) (youtube.com)

Employees, AI, and AI Employees (slobodan.me)

Free Software Street – Berga, Spain (en.wikipedia.org)

Show HN: I created my privacy first URL Shortener for fun. Hope you like it too (sawirly.com)

Scholarpedia, the peer-reviewed open-access encyclopedia (scholarpedia.org)

Persistence, façades and Roslyn's red-green trees (2012) (ericlippert.com)

Why Parquet Matters for Time Series and Financial Services (questdb.com)

DHH's "As I Remember London" (paulbjensen.co.uk)

Ask HN: HN – why no "Obituary" and "List of Legends" for coders of high merit?

Psst Want to see a cool bug? (bankstatementconverter.com)

Show HN: 90s Bollywood Saree Makeover from Any Selfie (No Login Required) (aisaree.net)

After Babel Fish (hedgehogreview.com)

Show HN: I built a HUD-like timer for macOS that stays visible in full-screen (apps.apple.com)

Silicon Foraging: Harvesting Excess Compute for Sustainable Edge Computing (siliconforag.ing)

Open Data Synthesis for Deep Research (arxiv.org)

Building AI, Backed by BTC (joandko.io)

Analysis of raw Waymo data shows fundamental safety improvements (twitter.com)

Safe Chain prevents developers from installing malware (npmjs.com)

Controlling program flow with capabilities in Scala (nrinaudo.github.io)

Facebook Research releases MapAnything, 3D reconstruction from images (github.com)

FCC Chairman Threatens ABC over Kimmel's Remarks About Charlie Kirk's Killer (variety.com)

Textbooks on algorithms for optimization, decision making, and validation (algorithmsbook.com)

Intro to Openstreetmap.org Operations (community.openstreetmap.org)

Algorithms are jailed in PDF files

First Open Conference of AI Agents for Science 2025 (agents4science.stanford.edu)

Simple pay-per-use database backup service (Postgres/MySQL/Mongo/More..)

Show HN: MiniMax Music – AI model that generates 4-minute songs (minimax-music.com)

Show HN: Underrated Postgres: Build Multi-Tenancy with Row-Level Security (simplyblock.io)

Hype Is a Business Tool (jenson.org)

Hacker Folklore – AI Koans (catb.org)

The Cache Crash (fastmail.com)

Notorious fraudster Marsalek thrives in Russia, now aids Russian FSB (english.nv.ua)

CERN scientists find evidence of quantum entanglement in sheep (home.cern)

R.e.l.i.v.e. – open-source engine for Oddworld: Abe's Exoddus and Oddysee (aliveteam.github.io)

Benchmark code for evaluating different ASR packages and APIs (github.com)

AI Watchdog – See whose work companies are using to train their models (theatlantic.com)

The Way of the Sea: Memory of Topography – Colors of Life (teamlab.art)

The Trump Administration Says IUDs and the Pill Are Abortions (jessica.substack.com)

Chimps consume equivalent of a beer a day in alcohol from fermented fruit (theguardian.com)

AI Psychosis and the Warped Mirror (pluralistic.net)

We Built the First AI-Generated Genomes (arcinstitute.org)

When Africa's internet breaks, this ship answers the call (restofworld.org)

Fast Fourier Transforms Part 1: Cooley-Tukey (connorboyle.io)

Click here if your branding is inconsistent (brandiseer.com)

SCREAM CIPHER ("ǠĂȦẶAẦ ĂǍÄẴẶȦ") (sethmlarson.dev)

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

Comments (4)