News for hackers. Stuff that matters.
Re:PostgREST – Serve a RESTful API from Any Postgres Database by smallnamespace on Thursday December 29, 2022 @12:31PM (#34175207)
PostgreSQL row-level security (which PostgREST defers to) is very flexible, more or less anything expressible as a SQL query can be used to filter what the user can see.

You can see an example here: https://postgrest.org/en/stable/auth.html#roles-for-each-web...

The main downside of RLS is that complex queries may require hand-optimizing.

There are no comments on this comment yet.