PostgREST: REST API for any Postgres database

Re:PostgREST: REST API for any Postgres database by tiew9Vii on Saturday November 21, 2020 @10:29PM (#25174716)

I often thought the same with the use of GraphQL. Instead of building a highly curated API with business logic, optimisations and other general stuff you are building a direct interface around how your data looks in the db, a 1:1 mapping and crud interface. In software we are taught to prefer loose coupling vs tight coupling yet here people are preferring the tight coupling.

I’m not a fan of this as the user interface (API) has a tight coupling with how you store your data. Then like you say, why not just speak SQL as you have all the same issues, essentially multiple clients writing to/owning the same tables.

[ Parent | on HN ]

Re:PostgREST: REST API for any Postgres database by taffer on Sunday November 22, 2020 @02:25PM (#25180227)

The PostgREST documentation makes it pretty clear that for decoupling and security reasons the data schema should be separated from the API schema. You should only provide the client with views and functions and keep all data in a separate schema. This also solves the versioning problem, because if your API schema is separate from your data, you can simply drop and re-create the entire schema for deployment without needing migrations.

[ Parent | on HN ]