Everything you need to know about Postgres Row Level Security

Post Content

​ Video of a conference talk about Postgres row level security presented by Paul Copplestone at POSETTE: An Event for Postgres 2024. In this talk we’ll cover everything you need to know about Row Level Security – what it is, when to use it, and how to write Policies that won’t impact your performance.

Paul is the CEO and co-founder of Supabase. Supabase is the Postgres developer platform that manages over a million Postgres databases. The are an open source company, contributing back to the ecosystem and employing maintainers of various Postgres tools.

Chapters:
00:00 – Intro
02:11 – What is row level security
04:25 – Why row level security
06:39 – How to implement row level security
09:41 – USING clause
11:03 – WITH CHECK clause
11:42 – One table can have multiple policies
12:56 – Do’s & Don’ts for row level security
17:23 – Tip & tricks

? Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette

✅ Learn more:
Watch more POSETTE talks: https://aka.ms/posette-playlist

? Let’s connect:
X – @PosetteConf https://x.com/PosetteConf
Mastodon – @posetteconf https://mastodon.social/@posetteconf
Threads – @posetteconf https://www.threads.net/@posetteconf

? Subscribe to the POSETTE News: https://aka.ms/posette-subscribe

? Slides for this talk: https://docs.google.com/presentation/d/1Ixe-72R1vpn59MEFetBmPe3JESHgz6BIsJRFx27ykZU/edit?usp=sharing

#PosetteConf #PostgreSQL #Database

Presenters:
Paul Copplestone, CEO at Supabase

Connect:
Paul Copplestone: https://twitter.com/kiwicopple, https://www.linkedin.com/in/paulcopplestone/   Read More Microsoft Developer