Hacker News new | ask | show | jobs
by qsort 1394 days ago
> There is no low-level API to SQL servers to create competition, so this is like saying CSS has no competition in browsers whatsoever.

Yes... but there is only one Web, and many databases. Some of them don't use SQL. They are, in my opinion, and in the opinion of many other developers, inferior. They lost in the market in a fair fight.

Also if SQL sucks so much you can compile to SQL, like TS->JS. Many such solutions exist. All worse than SQL.

> ORMs with their "relations" etc are basically better DSLs over SQL databases which try to hide rough edges from an innocent user.

ORMs are developed by software engineers for software engineers. It's kind of silly to picture them as "innocent" or incapable to understand the relational model.

> https://stackoverflow.com/a/3841804/3125367

Does having an operational semantics make a language not declarative? That's not how I use words. Is Haskell not functional because it runs on a GRS?

For the rest of your post you're arguing about either syntax, stuff you solve with CTEs, or stuff you would just hand off to the programming language, so I'll just leave it at that.

1 comments

So the hard parts were left at that and easy parts were dismissed as usual because one can CTEs all the way down. I shut up and go write three queries, manual joins and funny five-story self-joins, cause there is no problem. Who said it’s a language problem when it’s mine. Thanks for the explanation!