2 ms·
There seems to be very little support for these SQL challengers despite many people saying SQL sucks and they want a redo. Why is that? Some guesses: - There
by nonethewiser 3y ago
There seems to be very little support for these SQL challengers despite many people saying SQL sucks and they want a redo. Why is that?
Some guesses:
- There is some popular non-sql query language that has gained lots of momentum that I just dont know about.
- People are more effective with SQL because they know it so no new and especially existing databases will switch. This is definitely true to some extent, but if this is the whole reason then I guess SQL is pretty good since people rely on it to be effective.
- There is support for it but a few key decision makers are to blame (big data or the MYSQL lobbyists)
- People actually dont dislike SQL that much and/or its not that bad and hackernews is not representative
- These query languages look nice but have technical or performance issues compared to SQL
- rcme 3y agoI think the main reason mainline SQLs continue to be popular is that, unlike general purpose programming languages, the implementation of the query runner is the most important aspect, not then language spec. Take Python for instance. The official implementation objectively sucks, yet it remains extremely popular because the language implementation is only a part of a language’s success. That won’t fly for a db engine.
- erezsh 3y agoThe last one is definitely a big factor, combined with the fact that you still have to compile to SQL, i.e. you are limited by its limitations, and there isn't always a workaround. The rest are also true to some degree. But I think that once a serious contender comes along, people will eventually move to it.