On: When did Postgres become cool?

[booleanbetrayal]

The only correct answer to this question is 2012-09-10, the PostgreSQL 9.2 release date. In that release they unveiled JSON datatypes, and developers were able to have their cake and eat it too.

https://www.postgresql.org/about/news/postgresql-92-released...

https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_...

[lbotos → booleanbetrayal]

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."

[YeBanKo → booleanbetrayal]

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.

[Fire-Dragon-DoL → booleanbetrayal]

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

[evanelias → booleanbetrayal]

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

[Klonoar → booleanbetrayal]

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