Stop using mysql, you have postgres.
Stop using MySQL in 2026, it is not true open source
Submitted 1 month ago by otto@programming.dev to selfhosted@lemmy.world
https://optimizedbyotto.com/post/reasons-to-stop-using-mysql/
Comments
slacktoid@lemmy.ml 1 month ago
possiblylinux127@lemmy.zip 1 month ago
And mariaSQL
call_me_xale@lemmy.zip 1 month ago
Hell, even SQLite is good enough for most small projects.
immobile7801@piefed.social 1 month ago
FWIW mariadb was bought by a private equity firm in 2024
herseycokguzelolacak@lemmy.ml 1 month ago
Didn’t Postgresql effectively win the database wars? Why use anything else?
dogs0n@sh.itjust.works 1 month ago
Postgres or sqlite are the only ones I ever consider nowadays.
Takios@discuss.tchncs.de 1 month ago
If only the upgrade process wasn’t so annoying with postgres…
Hawk@lemmynsfw.com 1 month ago
See also duckdb and clickhouse for OLAP of course.
melfie@lemy.lol 1 month ago
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”
Hmm, MySQL or PostgreSQL—how will we ever decide which one to pick.
skisnow@lemmy.ca 1 month ago
wow, I didn’t need any more reasons not to support Oracle but thanks anyway
MrSoup@lemmy.zip 1 month ago
MariaDB >>>
YurkshireLad@lemmy.ca 1 month ago
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.
MrSoup@lemmy.zip 1 month ago
Blogs and forums back then when I looked it up.
Can’t remember exactly where (since it’s been a long time ago), but I’m sure more than someone claimed it.
Shimitar@downonthestreet.eu 1 month ago
If you don’t want to use postgresql for some obscure reason use MariaDB real open source MySQL drop in replacement.
schnurrito@discuss.tchncs.de 1 month ago
Are there real advantages to using either MySQL or MariaDB instead of PostgreSQL?
jubilationtcornpone@sh.itjust.works 1 month ago
No. But there are a number of advantages of using PostgreSQL over the others.
Rikj000@discuss.tchncs.de 1 month ago
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.
schnurrito@discuss.tchncs.de 1 month ago
That’s not what I asked. I asked about a comparison of both of them to PostgreSQL.
roguelazer@lemmy.world 1 month ago
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.
msage@programming.dev 1 month ago
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.
illusionist@lemmy.zip 1 month ago
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.
kumi@feddit.online 1 month ago
Operating and securing Postgres is a steeper learning curve.
msage@programming.dev 1 month ago
Is Maria that much better than MySQL?
Cause that one is absolute shit, very difficult to maintain, and requires lots of config changes and even replicas can disconnect when something’s not 100% ok.
I will take Postgres over any other DB any day of the week.
0_o7@lemmy.dbzer0.com 1 month ago
If you’re constrained by resources (CPU/RAM).
There’s a reason most web hosts usually have mariadb and not postgres.
Wispy2891@lemmy.world 1 month ago
Maybe that once every 2 years when you upgrade to major version it does it automatically? You save 15 mins every 2 years?
800XL@lemmy.world 1 month ago
What year is this? No one should be using Mysql since MariaDB came about.
BrilliantantTurd4361@sh.itjust.works 1 month ago
Why would anyone ever choose mysql over postgres?
Scrollone@feddit.it 1 month ago
MySQL has been the “default” choice for a long time for PHP programmers. I don’t know why.
whoisearth@lemmy.ca 1 month ago
It used to be free with less of a barrier to entry than poatgrea.
msage@programming.dev 1 month ago
Tutorials mostly.
0x0@lemmy.zip 1 month ago
No one should be using MySQL since 2010.
UnknownMp@lemmy.world 1 month ago
Perhaps MariaDB is a better choice.
unknownmp@mastodon.social 1 month ago
ikidd@lemmy.world 1 month ago
What rock do you live under if you’re using MySQL over MariaDB?
lechekaflan@lemmy.world 1 month ago
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.
dan@upvote.au 1 month ago
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.
possiblylinux127@lemmy.zip 1 month ago
That’s why I moved to MSSQL
/s
Grandwolf319@sh.itjust.works 1 month ago
But but but, it has the word “my” in it
/s
folekaule@lemmy.world 1 month ago
Both MySQL and MariaDb are named after the developer’s daughters.
androidul@lemmy.world 1 month ago
when is Oracle gonna go Broadcom mode on MySQL, still waiting for the moment 🍿
bored_boar_onboard@lemmy.world 1 month ago
Clearly you can’t use MySQL because it isn’t webscale.
fizzle@quokk.au 1 month ago
I didn’t know this was ever in question?
Also stop calling it “my sequel”
SneakyWeasel@lemmy.ca 1 month ago
Wamp anyone? (I think thats what its called, im at work and cant check my pc) Or am i the odd one out.
ianhclark510@lemmy.blahaj.zone 1 month ago
Apache Phoenix: allow me to introduce myself
otto@programming.dev 1 month ago
In case you are Czech, there is a translation at root.cz/…/prestante-uz-pouzivat-mysql-neni-to-sku…
Glad to see more translations show up!
GreenKnight23@lemmy.world 1 month ago
tacosanonymous@mander.xyz 1 month ago
Dude. You never finish.
JoMiran@lemmy.ml 1 month ago
MySQL belongs to Oracle. That’s literally all you need to.know in order to avoid it.
Image
FlowerFan@piefed.blahaj.zone 1 month ago
how did the joke go? “one rich asshole called larry ellison”?
ijhoo@lemmy.ml 1 month ago
what’s the joke part?
anomnom@sh.itjust.works 1 month ago
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
sobchak@programming.dev 1 month ago
Postgres is basically an open source version of Oracle DB. Much more featureful than MySQL. I believe Oracle bought MySQL just to kill it.
Jajcus@sh.itjust.works 1 month ago
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’.
Auli@lemmy.ca 1 month ago
MariaDB
Psythik@lemmy.world 1 month ago
JoMiran@lemmy.ml 1 month ago
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.
non_burglar@lemmy.world 1 month ago
When they bought Sun, they:
iturnedintoanewt@lemmy.world 1 month ago
news.ycombinator.com/item?id=34249580
forrgott@lemmy.zip 1 month ago
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…
jubilationtcornpone@sh.itjust.works 1 month ago
“Lets use Oracle DB for that.”
Statements made by the utterly deranged.
fizzle@quokk.au 1 month ago
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.
0x0@lemmy.zip 1 month ago
Have you been living under a rock? Think 2010 for starters…
Auli@lemmy.ca 1 month ago
People have hated Oracle for decades.