Re:Ask HN: What are some examples of good database schema de...
by ltbarcly3 on Friday February 14, 2020 @01:31PM
(#22328897)
Yes of course you cant allow uncontrolled sql execution, but an api that just maps to crud operations isn't good either.
[ Parent
| on HN ]
Re:Ask HN: What are some examples of good database schema de...
by BenjieGillam on Friday February 14, 2020 @05:53PM
(#22331236)
Agreed: an API that _just_ maps to CRUD operations isn’t good. I’m not advocating for that, neither is singingwolfboy, and the starter repo he’s linked to basically does not use them: there are only 4 CRUD mutations, all the others are custom. I rarely use CRUD operations in PostGraphile, mostly I use custom mutations either defined in SQL or TypeScript.
Re:Ask HN: What are some examples of good database schema de...
by iamaelephant on Friday February 14, 2020 @01:54PM
(#22329154)
Counterpoint yes it is.
Re:Ask HN: What are some examples of good database schema de...
by ltbarcly3 on Friday February 14, 2020 @08:36PM
(#22332419)
Not according to https://publications.opengroup.org/standards/soa
There is a lot of context lost in generalities so I admit you have to look at every specific situation, but in general CRUD means pushing business logic down to the client (which is generally some kind of code running in a browser or mobile app), which is the opposite of everything good in the world.