4 ms·
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
by booleanbetrayal 3y ago
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-1415/ https://www.postgresql.org/about/news/postgresql-92-released...
https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2#JSON_datatype https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_...
- Klonoar 3y agoArguably it’s really when they did jsonb, but otherwise I actually agree with you.
- lbotos 3y agoIt'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."
- evanelias 3y agoMySQL added a JSON column type just 3 years later though.
- YeBanKo 3y agoI 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 3y agoI thought exactly that, when postgres released json support, suddenly it was talked about everywhere