One Giant Leap for SQL: MySQL 8.0 Released

Re:One Giant Leap for SQL: MySQL 8.0 Released by MarkusWinand on Wednesday April 25, 2018 @01:21PM (#16923796)

A big red X doesn't mean the database doesn't have other, similar but proprietary functionality. It just means: it doesn't support this function in a standard confirming way yet.

There is nothing against using non-standard functionality in that case. In this particular case. PostgreSQL got JSON support (~2012?) long before it was added to the standard (2016). Obviously, their JSON functions differ from the standard (as they didn't lobby their functions into the standard).

However, slowly but surely database will add the standard functionality, which makes life easier.

Having that said, the standard JSON_OBJECTAGG is more powerful as it gives you control over null handling (NULL ON NULL -vs- ABSENT ON NULL) and allows checking for duplicate keys ([(WITH|WITHOUT) UNIQUE KEYS]).

[ Parent | on HN ]

Re:One Giant Leap for SQL: MySQL 8.0 Released by masklinn on Wednesday April 25, 2018 @01:46PM (#16924079)

Maybe add some little footnotes to the X? It took me a few minutes of thinking "Of course postgres has json object aggregation here it's working perfectly and it's documented" before I realised that sure it existed but it's not the standard version, at all, which is probably why it's marked as a no, because it's not Troel's page and Markus really really cares about the standard.

[ Parent | on HN ]