Designing the most performant Row Level Security(RLS) schema in Postgres
The main hypothesis is that we should be able to prevent access to specific rows of data based on a policy. That means our application logic only has to worry about SELECT * FROM my_table and RLS will handle the WHERE user_id = my_user_id part automagically.
Appears in lists (1)
More like this (2)
Row Level Security, Views and a Lot of Magic — Row Level Security (RLS) is a...Row Level Security, Views and a Lot of Magic — Row Level Security (RLS) is a key Postgres feature that lets you define granular policies on which rows specific users can view or manipulate. Here’s a look at how they work and a problem Crunchy Data discovered with the feature.