Hacker News new | ask | show | jobs
by flakiness 1506 days ago
I love the attitude towards ergonomics over standard compliance. And you'll see why SQL has never been really portable across databases ;-)
2 comments

Maybe if SQL was a better language at the start, there would be more incentive to follow the spec.
IIRC there was am ANSI/FIPS standard which was dropped under the bill clinton's administration, which is when things started to diverge.

(Info from memory, may be wrong or a bit mangled)

SQL is an amazingly good language for what it does. It has been with us coming up on 5 decades.
Minus everyone having different versions of it to facilitate the missing functionality/needs of users
Well, it's not portable, but you don't have to learn a new language every time you encounter a new DBMS (unlike MongoDB or InfluxDB).