News for hackers. Stuff that matters.
Re:PostgREST – Serve a RESTful API from Any Postgres Database by lelanthran on Thursday December 29, 2022 @04:42PM (#34178405)
Yeah, but this particular contract/API is pretty much "run arbitrary select/insert/update/delete statements" anyway!

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?

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.