News for hackers. Stuff that matters.

A comment on Things to know about databases. Parent comment

Re:Things to know about databases by N_A_T_E on Monday June 27, 2022 @04:00PM (#31899981)
Isn't that what the ActiveRecord pattern is supposed to be? (Something something n+1's and over fetching data.)
[ Parent | on HN ]
Re:Things to know about databases by eurasiantiger on Monday June 27, 2022 @04:35PM (#31900433)
If only we had a generic GraphQL resolver for entity-based SQL schemas.

Oh wait, we do have Prisma. And it suffers from those same issues.

[ Parent | on HN ]
Re:Things to know about databases by drpotato on Monday June 27, 2022 @05:06PM (#31900795)
Have you looked at PostGraphile? It’s doesn’t have n + 1 or over-fetching issues.
[ Parent | on HN ]
Re:Things to know about databases by eurasiantiger on Tuesday June 28, 2022 @12:07PM (#31909508)
I have, and I would recommend it, if it generated a Postgre schema from a GraphQL schema and not the other way around.

The advantages of GraphQL are its integration of backend and frontend workflows, and that won’t happen with PostGraphile: a frontend needing a schema change needs to go through the backend instead of the backend extending to meet the frontend in the middle.

[ Parent | on HN ]