51–60 of 182 posts
I see a lot of comment reflecting on MySQL and oracle vs postgresql. Anyone with experience of MSSQL and PostgreSQL who'd like to comment on how it they compare?
However IMHO MySQL still wins in operational efficiency and performance. These are things that only start to matter when you scale your database and most people never actually reach those sizes.
Was it that Postgres became cool or that MySQL became unreliable post-Oracle and developers were looking for an alternative?
Earlier quoted context omitted.
It was way before that - it was when people got fed up with the string handling and implicit type casting stupidity of MySQL
This 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).
When MySQL was purchased by Oracle. For a time, MariaDB was the new option, but its commitment to binary compatibility with MySQL made it feel bogged down. Fun fact: Julian Assange contributed code to PostgreSQL a long time ago: https://news.ycombinator.com/item?id=18464671
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.
So ca 2010, maybe just a little earlier?
It was a good tool, and it still is. There is no marketing, no fluff, no buzz world.
It gets the job done.
That's what's good about it.
Earlier quoted context omitted.
This 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).
The 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.
MariaDB.