4 ms·
Postgres became cool when the scales fell off peoples eyes and they realized that very few use cases necessitate or even benefit from "NoSQL" databases.
by xnx 3y ago
Postgres became cool when the scales fell off peoples eyes and they realized that very few use cases necessitate or even benefit from "NoSQL" databases.
- dymk 3y agoIt was way before that - it was when people got fed up with the string handling and implicit type casting stupidity of MySQL
- Avshalom 3y agoIt was excellent and recommended over MySQL before but I agree it became "cool" in the wake of the mongodb/nosql hype->trough of disillusionment transition.
- pessimizer 3y agoI think that also came late. It was when Oracle bought Sun. People who needed a drop-in replacement moved to MariaDB, but it was the last straw for people who were creating new projects and sort of hated MySQL anyway. Everybody remembered the other one.
- pixl97 3y agoI think a large amount of mysql was based on PHP applications with default mysql support.
- fjfuvucucuc 3y ago[dead]
- weinzierl 3y agoThis is also my opinion and I think before that MySQL was known for fast and Postgres for features and correctness. I think the change went both ways, people realized that MySQL's casual approach only got them so far and at the same time Postgres focused more on performance without giving up its existing qualities. I think Postgres became cool when it became fast (too).
- ASalazarMX 3y agoThe last straw was when Oracle bought MySQL, and it was forked to MariaSQL. Postgres went from the nerdy awkward kid to the nerdy cool kid, while MySQL started drinking, getting split personalities, and living off his past fame.
- CRConrad 3y ago> MariaSQL MariaDB.
- hashtag-til 3y agoThe “new” name never really stick…
- CRConrad 3y agoWas MariaDB ever called MariaSQL? When?
- hashtag-til 3y agoI referred to MySQL vs MariaDB
- CRConrad 3y agoThen you were even more wrong. MariaDB wasn't just "a new name" for MySQL.
- ASalazarMX 3y agoIt was my mistake, I misremembered MariaDB, but can't edit my comment now. In my defense, I've barely thought of it since 2009, when it was forked. On the other hand, I've worked with MySQL a few times in the same period, mostly because Oracle, whatever its failings, has kept MySQL alive. Not thriving, but alive. I'm so glad they didn't buy PostgreSQL.
- weare138 3y agoI think all the drama with Oracle acquiring MySQL may have contributed to the situation too.
- lsaferite 3y agoOne of mine is the lack of transactional DDL.
- thewix 3y agoYou get JSON types with postgres. If you aren't sharing data between tables then json is fine
- nomel 3y agoYou get JSONB with postgres, which, to me, is a significant difference. This means you can indexing by key/value, access keys directly, without parsing the whole json string, etc. For my use case, JSONB support completely killed most NoSQL solutions.
- thewix 3y agoSorry, I should have said JSONB. Do you still consider a table with a single JSONB column SQL or NoSQL? Sure, it may be contained within a RDBMS but you are treating it more like a document store than a relationship database.
- nemo44x 3y agoNoSQL is as popular as it has ever been though. Many of those most popular NoSQL DBs have outgrown the general database market for a decade and it doesn’t look to be slowing down. Saying that, SQL databases are still the king by a wide margin. Postgres has grown more at other SQL DBs expense than anything.
- xnx 3y ago> NoSQL is as popular as it has ever been though. Indeed. I was surprised to find that search volume is about as high as it has ever been: https://trends.google.com/trends/explore?date=all&q=nosql&hl=en https://trends.google.com/trends/explore?date=all&q=nosql&hl...