Remix.run Logo
tmoertel 4 hours ago

The problem with alternative query languages is that the people who have the most knowledge about creating queries and of the relational domains underlying their businesses are all experts in SQL. Introducing something else, then, means your most natural user base must migrate away from something they understand how to use well, and that's a hard sell.

So, until the ultimate query language is developed, I'll take SQL with pipes. It's an easy sell and good enough to eliminate 90% of my gripes about SQL.

taybin 4 hours ago | parent | next [-]

This is exactly the same problem facing people trying to develop new music notations. In order to grasp the domain enough, they have to be experts in the existing music notation, and once you're an expert in it, the motivation to create something new goes away. From what I've seen, the people who want a new music notation are mostly people uncomfortable with sight reading.

AlotOfReading 4 hours ago | parent [-]

Experts have been criticizing SQL since it was a proprietary IBM language. Take this typewritten rant from 1983 [0] as an example. And we've had better query languages for just as long, e.g. datalog. People really love SQL though, which I can only assume is because the vast majority of usecases are slight variations on SELECT * FROM table.

[0] https://courses.cs.duke.edu/spring03/cps216/papers/date-1983...

g-b-r 2 hours ago | parent [-]

I hardly doubt that many people love SQL

They might love the relational model concepts that manage to seep through it

likium 3 hours ago | parent | prev | next [-]

Exactly, we all know the merits of Esperanto, but few have switched away from English.

smitty1e 4 hours ago | parent | prev [-]

For example, Elastic. Much extra learning curve for little obvious gain.

I like to say, with zero research basis, that the New Shiny has to be an order of magnitude better than the Old Thing for people to say "Oh yeah, I gotta have that."