Care to expand on why MySQL < 8 will be problematic for analysts? Anything else ... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

sslalready on July 16, 2019 | parent | context | favorite | on: Anyone made the jump from MySQL to PostreSQL? It i...

Care to expand on why MySQL < 8 will be problematic for analysts? Anything else than the lack of window function?

oarabbus_ on July 16, 2019 | [–]

IMO lack of window functions alone are a death knell.

CTEs/WITH clause is the other massive one - almost as important as window functions.

Additionally, EXCEPT/INTERSECT support, better EXPLAIN (it's still shit though), much improved REGEXP and JSON support.

paulryanrogers on July 16, 2019 | | [–]

Possibly JSON operators

jimktrains2 on July 16, 2019 | [–]

Window functions.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact