Re:PostgREST 9.0
by BenjieGillam on Tuesday November 30, 2021 @05:22AM
(#29390684)
That's not true; you can use row level security (RLS) to control access (both reading and writing) on a per-row basis. You can think of it as similar to an implicit "where" clause that automatically gets added to all requests.
RLS: https://www.postgresql.org/docs/current/ddl-rowsecurity.html
Re:PostgREST 9.0
by lisperforlife on Tuesday November 30, 2021 @12:45PM
(#29395017)
We built an entire system using RLS and functions. Postgraphile is frankly amazing. You can also extend the schema using Typescript or SQL.
If you completely trust your users, that's fine.