Postgres Row Level Security

Ask an organizer about our Slack group if you'd like to attend. We share a Zoom link in Slack just before the meeting starts. Thanks!

***

Book Club (for those interested, feel free to listen in):

Code Complete 2nd Edition by Steve McConnell - Chapter 8, from page 187 to 213.

We'll wrap up the meeting around 7:20 pm and the focus will switch over to a book club discussion for the last 30 minutes or so.

***

Meeting Overview:

We’re going to use PostgreSQL Row Level Security (RLS) to work through some real-world authorization scenarios together. Row Level Security is a built-in Postgres feature that lets you control which rows a user can see, insert, update, or delete, directly in the database. It’s a practical way to keep data access rules consistent, especially in multi-tenant apps and systems where different users should only see their own data.

We’ll start with a simple table and a basic “users can only access their own rows” rule. It’s a hands-on way to learn how RLS actually behaves, pick up patterns you can reuse, and get comfortable treating the database as part of your security model—not just a place to store data.

***

General Agenda:

6:00 pm MT - Welcome and setup
6:05 - Start the Meeting
7:20 - Wrap up discussion and begin book club
7:50 - Close for the night

Meeting tools:
Slack: https://slack.com/
Discord: https://discordapp.com
Zoom: https://zoom.us/

Kalispell Software Crafters is dedicated to a harassment-free experience for everyone. Be that at an event or within our Slack and Discord community. Our anti-harassment policy can be found at: https://github.com/kalispell-software-crafters/code-of-conduct