We Can Do Better Than SQL

Re:We Can Do Better Than SQL by sanderjd on Tuesday August 11, 2020 @10:50AM (#24120851)

That seems like a completely different point. (Unless I misunderstand what a "SQL validator" is, which is definitely possible.)

I do think this way of utilizing SQL is a problem, but I would lay the blame for it at the feet of a lamentably widespread anti-intellectualism in the field. It is true that the relational model is not trivial and must be learned before SQL makes much sense. But it is not too much to expect from someone who wants to be a practitioner in this field.

[ Parent | on HN ]

Re:We Can Do Better Than SQL by mannykannot on Tuesday August 11, 2020 @11:23AM (#24121263)

I agree that someone who wants to be a practitioner in this field should understand the relational model, but the issue here is that SQL introduces inconsistencies and complications that are not inherent in the relational model, and, to some extent are avoidable. A justifiable emphasis on professionalism does not absolve SQL of these faults and does not render irrelevant attempts to find better language choices.

[ Parent | on HN ]

Re:We Can Do Better Than SQL by sanderjd on Tuesday August 11, 2020 @10:24PM (#24128023)

Sure, I don't disagree. My point is that the perfect is the enemy of the good, and SQL is the good.

[ Parent | on HN ]