Hacker News new | ask | show | jobs
by whstl 420 days ago
PostgREST creates the same type of CRUD endpoint that one would create when writing a traditional backend with an (eg) MVC framework, and it does this without requiring a developer and with complete consistency.

If "letting the client formulate queries" you mean "filter posts by DidYaWipe, sorting by date", this is also what traditional CRUD backends do.

1 comments

I wouldn't write a back end with an MVC framework, since it's not doing any presentation whatsoever.

If PostgREST auto-generates three-table joins automatically to resolve many-to-many relationships and presents an appropriate endpoint, that's interesting.

Yes, it does many-to-many joins automatically: https://docs.postgrest.org/en/v12/references/api/resource_em....
Thanks for the reference. I'll check it out!