Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
4.1K views 10 months ago #PostgreSQL #Database #PosetteConf
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/po …...more
...more
Everything you need to know about Postgres Row Level Security | POSETTE 2024
169Likes
4,163Views
Jun 132024
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  

Follow along using the transcript.

Microsoft Developer

588K subscribers