MySQL belongs to Oracle. That’s literally all you need to.know in order to avoid it.
Isn’t that the point of Postgresql. It’s basically an open source version of MySQL.
I’m sure there are some proprietary nonsense that MySQL has, but I’ve never needed it in 17 years
Postgres is basically an open source version of Oracle DB. Much more featureful than MySQL. I believe Oracle bought MySQL just to kill it.
MySQL always sucked ass.
PostgreSQL went in a different direction, started with best support of the SQL standard, then optimized everything to make it fast.
Postgres has/had the best SQL standard support out of every server, open-source or not.
MySQL was at the other end, only started catching up after Oracle bought it.
That is an insult to PostgreSQL. PostgreSQL was fully featured relational database even before it implemented SQL. It started much earlier tha MySQL.
And MySQL didn’t have proper transactions or data integrity constraints (including foreign keys) for long time, while calling itself an ‘SQL database’.
Thank you, I never had time to read up on its history when I was busy smashing out sites on stupid deadlines with constant last minute changes and morons for project managers.
MariaDB
deleted by creator
Hatred of Oracle predates “cancelling” by decades. Oracle is and has always been one of, if not the most disgusting and vicious companies in tech. They kill everything they touch.
If you need a political component, then Oracle = Larry Ellison, but Oracle hate predates and supercedes the American political slide into fascism.
I was at a party about fifteen years ago. A guy introduced himself and we gabbed for a few minutes. Then he asked what I do for work (IT sysadmin at the time) and I told him and asked the same. He said he was in sales for a tech company. I asked which one, and he stepped close and whispered, “Oracle.” I could see he was prepared for me to bring the hate. He saved himself when he told me he was actually leaving for a gig at Dell. Later, I learned from the host that he made that part about leaving up because he felt bad. I later learned he went to work for Nutanix. Poor guy hated his own employer, and it was obvious.
Nutanix…oof. I deal with them every day. It isn’t their fault their shit can’t handle what we do, but it is their sales folk that constantly lie and misrepresent.
Wanna know one of rhe big reasons people hate Oracle so much? It’s their sales guys. They are awful. If that guy went from Oracle to Nutanix, that tells me that I cannot trust a single syllable out of their mouth.
Lol! I’m glad you picked on that. I won’t badmouth them, but the user experience does that for them. That guy from the party must hate himself, haha
When they bought Sun, they:
- killed Solaris, effectively
- tried to kill zfs too
- nearly killed mysql with licensing audits
- became borderline evil with licensing practices
- acted like complete assholes in court, holding up cases for years
Sun was such a useful contributor to the ecosystem and they fucking trashed absolutely everything. It’s a miracle that so much stuff could be saved.
“Lets use Oracle DB for that.”
Statements made by the utterly deranged.
Oh so it’s a greed thing, but not quite a Nestlé level of evil thing, then. Meh.
People have hated Oracle for decades.
Stop using mysql, you have postgres.
Didn’t Postgresql effectively win the database wars? Why use anything else?
Postgres or sqlite are the only ones I ever consider nowadays.
If only the upgrade process wasn’t so annoying with postgres…
What do you mean?
Stop DB, run pg_upgrade, start it, win?
Or set up logical replication into newer version, wait for sync, test use-cases, switch write?
Where do you get better experience?
See also duckdb and clickhouse for OLAP of course.
What year is this? No one should be using Mysql since MariaDB came about.
Why would anyone ever choose mysql over postgres?
Are there real advantages to using either MySQL or MariaDB instead of PostgreSQL?
No. But there are a number of advantages of using PostgreSQL over the others.
MySQL often has moderately higher performance (particularly for workloads where you want your data clustered by PK, which is how InnoDB is natively structured) and its replication system is much more flexible than either of PostgreSQL’s. I like Percona personally, but MariaDB is fine too.
Is it true?
Postgres with correct fillfactor, it doesn’t create new pages and works very fast.
Replication in MySQL always sucked ass, only received synchronous replication in some new edition, and that also didn’t sound great.
Postgres has logstream and logical replication, both of them can be set to various levels of synchronicity, and logical replication is configurable at least as well as MySQL is in terms of which data is sent.
If you’re constrained by resources (CPU/RAM).
There’s a reason most web hosts usually have mariadb and not postgres.
Yeah,
I did a speed test comparison between Oracle MySQL and MariaDB MySQL,
MariaDB is about 10 times faster.FYI: When Oracle bought MySQL a lot of developers left and created MariaDB, so the brains behind the project moved, and in the meantime Oracle did a great job of fucking things up.
That’s not what I asked. I asked about a comparison of both of them to PostgreSQL.
Oh misread my bad,
not much experience with PostgreSQL
Maybe that once every 2 years when you upgrade to major version it does it automatically? You save 15 mins every 2 years?
Perhaps MariaDB is a better choice.
What rock do you live under if you’re using MySQL over MariaDB?
Older people about to return to programming, and most of the online tutorials they have are about 20 years old, having no idea an alternative exists.
when is Oracle gonna go Broadcom mode on MySQL, still waiting for the moment 🍿
Clearly you can’t use MySQL because it isn’t webscale.
Wamp anyone? (I think thats what its called, im at work and cant check my pc) Or am i the odd one out.
Apache Phoenix: allow me to introduce myself
Who?
Apache Phoenix
Looks great for my blog!
Dude. You never finish.
But but but, it has the word “my” in it
/s
Both MySQL and MariaDb are named after the developer’s daughters.
In case you are Czech, there is a translation at https://www.root.cz/clanky/prestante-uz-pouzivat-mysql-neni-to-skutecny-open-source/?nahled=1
Glad to see more translations show up!
