undefined | Better HN

0 pointsbafe2y ago0 comments

Your website is great and I regularly check it to see what's new in various implementations. Unfortunately it seems that many databases don't support many modern SQL features yet. Any ideas as to why?

0 comments

mdaniel2y ago

> Unfortunately it seems that many databases don't support many modern SQL features yet. Any ideas as to why?

I'd guess the incentive structure is the opposite of what you're implying; the same reason why every cordless drill manufacturer has their own battery connector: vendor lock in fuels private planes and shareholder reports, versus being compatible means no one is forced to buy your batteries and thus profits are `$total - $forced_purchases`

This situation gets even worse in the case of a standard without any objective way of knowing one is in compliance. Having a badge on the mysql.com website saying "now featuring SQL:2023 compliance!11" sells how many more support contracts exactly?

bafeOP2y ago

That's a good point. Additionally, it seems the standard isn't freely available and I doubt most of the developers of existing SQL DBs partecipate in drafting new standards. It seems it is doomed to diverge even further, which begs the question whether is it relevant anymore to have the SQL standard at all

j / k navigate · click thread line to collapse

0 comments

mdaniel2y ago

> Unfortunately it seems that many databases don't support many modern SQL features yet. Any ideas as to why?

bafeOP2y ago

j / k navigate · click thread line to collapse