Company
Date Published
Nov. 13, 2024
Author
David Gomes
Word count
351
Language
English
Hacker News points
1

Summary

Postgres Row-Level Security (RLS) can be challenging to understand and use. A more concise API specifically designed for CRUD apps has been developed, which includes the crudPolicy function with inputs such as role, read, and modify policies. The authUid function is specific to pg_session_jwt and allows connecting auth.user_id to a table column. This higher-level abstraction on top of Postgres RLS aims to assist developers in using RLS effectively. A future blog post will provide a reference RLS implementation for a social media network.