/plushcap/analysis/neon/neon-higher-level-crud-abstraction-for-postgres-rls

Higher-level CRUD Abstraction for Postgres RLS

What's this blog post about?

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.

Company
Neon

Date published
Nov. 13, 2024

Author(s)
David Gomes

Word count
351

Language
English

Hacker News points
1


By Matt Makai. 2021-2024.