Writing

Notes from the build,
not from the pitch deck.

What things actually cost, what production actually requires, and what we would tell you on a call before you spent any money. No listicles.

LatestEngineering

Supabase Row Level Security: The Complete Guide

Every policy you need, the four mistakes that leak data, and how to prove your rules actually work. With copy-paste SQL.

9 min read
In short

Row level security decides which rows each user can see, and in Supabase it is the only thing standing between a logged-in user and your whole table, because the database is exposed directly to the browser. Enable it on every table holding user data, then write a separate policy for SELECT, INSERT, UPDATE and DELETE. The four mistakes that cause real leaks are a policy of USING (true), covering SELECT but not the write commands, putting a role column in a user-writable table, and never testing as a second user.

Read the full post

Rather just ask us directly?

Tell us what you're trying to build. We'll scope it with you in a 30-minute call, free.