News for hackers. Stuff that matters.
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.
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.