Re:PostgREST – Serve a RESTful API from Any Postgres Database
by aljarry on Friday December 30, 2022 @07:21AM
(#34184368)
Yes, but the REST vs SQL forces a specific API for changes. REST - update/delete a specific record. SQL - update/delete based on a filter, or a query result. I can do `set a = b` for all rows in the table, which may be needed internally, but it's a pretty bad external interface.
If you're using the postgrest language your options to stabilise the interface are minimal anyway, so why not just go with SQL and a whitelist?