We Can Do Better Than SQL

Re:We Can Do Better Than SQL by m000 on Tuesday August 11, 2020 @06:26AM (#24118903)

Python and English are meant to be general purpose languages, so they are kind of expected to be large and occasionally inconsistent. SQL is (by definition) a domain-specific language which has grown out of proportions.

Are there really any SQL libraries in the traditional sense (i.e. reusable/composable SQL code with a well specified API)? SQL "libraries" typically focus on hiding the inconsistencies and the abhorrent syntax under the carpet.

And the user base is there, mostly because of the database engine properties and features. The query language itself is just a bad side-effect. And TFA does make a point that NoSQL abandoning the underlying RDBMS model is in fact a regression.

[ Parent | on HN ]

Re:We Can Do Better Than SQL by bmh100 on Tuesday August 11, 2020 @11:21AM (#24121237)

SQL is designed around databases. Python is designed around objects. Clojure is designed around expressions. A table is analogous to a list of objects. None of these languages is more domain-specific than any other.

[ Parent | on HN ]

Re:We Can Do Better Than SQL by Areading314 on Tuesday August 11, 2020 @01:46PM (#24123315)

Perhaps libraries doesn't really apply to SQL per se, but instead you have tooling, ecosystem, DB engines, ORMs, extensions etc, that all speak SQL and would be hard to do without.

[ Parent | on HN ]