Hacker News Reader

It's funny because I was going to say circa 2012. Working at Linode I definitely saw a shift away from MySQL to Postgres around that time, but I didn't have any over arching reason beyond "it was trendy."

I think CTEs and window functions in version 8 were big, combined with udf you could write some very complicated queries for data analysis without exponentially growing number of joins.

I thought exactly that, when postgres released json support, suddenly it was talked about everywhere

MySQL added a JSON column type just 3 years later though.

Arguably it’s really when they did jsonb, but otherwise I actually agree with you.