Dude. You never finish.
Why would anyone ever choose mysql over postgres?
MariaDB is not always a drop-in replacement. There’s several features that MySQL has that MariaDB doesn’t, especially related to the optimizer (for some types of queries, MySQL will give you a more optimized execution plan compared to MariaDB). It’s also missing some newer data types, like JSON (which indexes the individual fields in JSON objects to make filtering on them more efficient).
MariaDB and MySQL are both fine. Even though MySQL doesn’t receive as much development any more, it doesn’t really need it. It works fine. If you want a better database system, switch to PostgreSQL, not MariaDB.
Are there real advantages to using either MySQL or MariaDB instead of PostgreSQL?
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
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.
Depends on the task but for general usage there is no big difference. You would choose one over the other if you need one for work.
No. But there are a number of advantages of using PostgreSQL over the others.
Operating and securing Postgres is a steeper learning curve. MariaDB is more forgiving for best-effort shoestring setups without compensating scalability for it.
As a dev I’m agnostic, as an owner and computer scientiest I prefer Postgres, as a sysadmin or *Ops I will put my hand up for MariaDB any day if I’ll be on call or maintain deployments.
That’s why I moved to MSSQL
/s
But but but, it has the word “my” in it
/s
Both MySQL and MariaDb are named after the developer’s daughters.
Apache Phoenix: allow me to introduce myself
Who?
MySQL belongs to Oracle. That’s literally all you need to.know in order to avoid it.
I can’t keep track of all this shit we’ve canceled. The hell did Oracle do?
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.
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
Sales? No, their sales department is second to their legal department in hate.
Why would you keep track? Can’t form your own opinions?!
And what the fuck hasn’t Oracle done? Like, seriously, they’ve been a known bad actor for literally decades now…
I’m sorry I don’t follow this company’s actions as closely as you do. I can’t even remember the last time I used Oracle-branded software. (Unless you count MySQL, which I’ve never had an issue with. It just works.)
“Lets use Oracle DB for that.”
Statements made by the utterly deranged.
I don’t know the actual reason, but I personally get a bad vibe every time I see the logo because usually it means I’m trying to install or fix some java bullshit, which never goes well.
Oh so it’s a greed thing, but not quite a Nestlé level of evil thing, then. Meh.
You clearly haven’t tried using one of there services APIs.
I mean, Nestlé killed hundreds of thousands in impoverished countries. I think the Oracle service APIs can’t be that bad, though I’m sure they would be if it made Larry Ellison $50.
Only due to lack of capability, not desire.
how did the joke go? “one rich asshole called larry ellison”?
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.
Stop using mysql, you have postgres.
And mariaSQL
FWIW mariadb was bought by a private equity firm in 2024
Oh no… it was the easy solution for Wordpress and other plug and play self hosted services .
Hell, even SQLite is good enough for most small projects.
SQLite is underrated. I’ve used it for high traffic systems with no issues. If your system has a large number of readers and a small number of writers, it performs very well. It’s not as good for high-concurrency write-heavy use cases, but that’s not common (most apps read far more than they write).
My use case was a DB that was created during the build process, then read on every page load.
Wow, I never thought about storing build data in an SQLite file. That’s quite clever.
One of SQLite’s recommended use cases is as an alternate to proprietary binary formats: https://sqlite.org/appfileformat.html. Programs often store data in binary files for performance, but you get a lot of the same functionality included with SQLite (fast random access, concurrent usage, atomicity, updates that don’t need to rewrite the whole file, etc) without having to implement a file format yourself.
I’m not sure if this is still the case, but Facebook’a HHVM used to store the compiled bytecode for the whole site in a single SQLite database: https://docs.hhvm.com/docs/hhvm/advanced-usage/repo-authoritative/. Every pageload loaded the bytecode for all required files from the DB.
MariaDB >>>
I’ve been using it since ever on my rpi because they say it’s easier on resources
Who are “they”?
We use MariaDB at work but I don’t know why it was originally chosen over PostgreSQL, as that was before my time.
I didn’t know this was ever in question?
Also stop calling it “my sequel”
stop calling it “my sequel”
Why?
Sequel is Microsoft. S-Q-L is Linux.
Microsoft’s is “squeal”. Like a pig. When you get the bill.
Oracle sees itself as an activist organization, one whose goal is the advancement of the Israeli colonization project. Safra Catz, the company’s Israeli-American CEO, bluntly explained that any employees uncomfortable with supporting a genocide should simply quit. “We are not flexible regarding our mission, and our commitment to Israel is second to none” (source)
Hmm, MySQL or PostgreSQL—how will we ever decide which one to pick.
