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: aka.ms/posette
✅ Learn more:
Watch more POSETTE talks: aka.ms/posette-playlist-2024
📌 Let’s connect:
X - @PosetteConf x.com/PosetteConf
Mastodon - @posetteconf mastodon.social/@posetteconf
Threads - @posetteconf www.threads.net/@posetteconf
🔔 Subscribe to the POSETTE News: aka.ms/posette-subscribe
📣 Slides for this talk: docs.google.com/presentation/...
#PosetteConf #PostgreSQL #Database
Presenters:
Paul Copplestone, CEO at Supabase
Connect:
Paul Copplestone: / kiwicopple , / paulcopplestone
Негізгі бет Ғылым және технология Everything you need to know about Postgres Row Level Security | POSETTE 2024
Пікірлер