Everything you need to know about Postgres Row Level Security | POSETTE 2024

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-2024

📌 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/...

#PosetteConf #PostgreSQL #Database

Presenters:
Paul Copplestone, CEO at Supabase

Connect:
Paul Copplestone:   / kiwicopple  ,   / paulcopplestone