MySQL belongs to Oracle. That's literally all you need to.know in order to avoid it.
how did the joke go? "one rich asshole called larry ellison"?
what's the joke part?
It spells Oracle.
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.
afaik MariaDB is the open source version of MySQL
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'.
Stop using mysql, you have postgres.
And mariaSQL
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.
FWIW mariadb was bought by a private equity firm in 2024
Didn't Postgresql effectively win the database wars? Why use anything else?
Postgres or sqlite are the only ones I ever consider nowadays.
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.
If you don't want to use postgresql for some obscure reason use MariaDB real open source MySQL drop in replacement.
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.
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.
What year is this? No one should be using Mysql since MariaDB came about.
Why would anyone ever choose mysql over postgres?
MySQL has been the "default" choice for a long time for PHP programmers. I don't know why.
LAMP indeed
It used to be free with less of a barrier to entry than postgres
Perhaps MariaDB is a better choice.
No one should be using MySQL since 2010.
What rock do you live under if you're using MySQL over MariaDB?
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.
That's why I moved to MSSQL
/s
A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.
Rules:
Be civil.
No spam.
Posts are to be related to self-hosting.
Don't duplicate the full text of your blog or readme if you're providing a link.
Submission headline should match the article title.
No trolling.
Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details. Tags [CBH] or [AIP] are required, see the links in Rule 8 for details.
AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post, and find example disclosures here.
Resources:
Any issues on the community? Report it using the report flag.
Questions? DM the mods!