Why would anyone use MySQL over Postgres in 2026?
Stop using MySQL in 2026, it is not true open source
21–30 of 37 posts
Re: Stop using MySQL in 2026, it is not true open source
#22From my experience MariaDB is not necessarily better than MySQL. The 8.x line brought many interesting features. I dream on switch to Postgres, and try every year but for my use case MySQL is still superior (100Bi+ rows for large texts, and heavy modified - I´m also space constrained - So I need data compression and the VACUUM are not good.) The percona distribution is very good!
From my experience, mariadb is about the same as mysql... depending on the queries, it can either be fine, or slow as balls. I'm actually considering switching to pgsql to see if its any better. /shrug
Re: Stop using MySQL in 2026, it is not true open source
#23I'm stuck on MySQL because converting to postgres is hard, the tool everyone recommends (pgloader) doesn't work with current MySQL ( https://github.com/dimitri/pgloader/issues/782 ), anyone know another way?
It does work, I just used pgloader to migrate a 16 GB database from MySQL 8.4 to PostgreSQL 18 last week (around 700 tables). It's not big, but their problems seem to be with authentication, not database size or functionality. Have you tried it doing it yourself?
I have tried. It fails in authentication like that ticket describes, so I seem to be stuck on square one.
Re: Stop using MySQL in 2026, it is not true open source
#24Why would anyone use MySQL over Postgres in 2026?
Because they started with MySQL and it can be difficult to switch.
Re: Stop using MySQL in 2026, it is not true open source
#25One does not need to stop because "its not open source", one needs to switch because its no longer actively being developed.
Re: Stop using MySQL in 2026, it is not true open source
#26From my experience MariaDB is not necessarily better than MySQL. The 8.x line brought many interesting features. I dream on switch to Postgres, and try every year but for my use case MySQL is still superior (100Bi+ rows for large texts, and heavy modified - I´m also space constrained - So I need data compression and the VACUUM are not good.) The percona distribution is very good!
Is there anything in 8.0.x/8.4.x line that isn't present in MariaDb latest?
Re: Stop using MySQL in 2026, it is not true open source
#27The author is right that usage is dropping, but that really has no bearing on whether or not it is open source. Technologies get replaced all the time regardless of the license they use.
Author is also being careful with the DB-Engines screen shot, usage of MySQL may be dropping, but it's still number two (below Oracle, above MSSQL - which shows the same curve, above Postgres, far above MariaDB and SQLite) https://db-engines.com/en/ranking_trend
The rankings methodology looks like it will favour MySQL.
https://db-engines.com/en/ranking_definition
Lots of historical mentions. Even the MariaDB website mentions it. Lots of people say "MySQL" generically to include its forks.
Re: Stop using MySQL in 2026, it is not true open source
#28Earlier quoted context omitted.
Author is also being careful with the DB-Engines screen shot, usage of MySQL may be dropping, but it's still number two (below Oracle, above MSSQL - which shows the same curve, above Postgres, far above MariaDB and SQLite) https://db-engines.com/en/ranking_trend
The rankings methodology looks like it will favour MySQL. https://db-engines.com/en/ranking_definition Lots of historical mentions. Even the MariaDB website mentions it. Lots of people say "MySQL" generically to include its forks.
You can see that in this comment thread too. People assuming MariaDB=MySQL (not according to op, arguable)
Re: Stop using MySQL in 2026, it is not true open source
#29Earlier quoted context omitted.
How big of a DB are we talking about? You might need to recreate the whole DB schema / structure manually from scratch in PostgreSQL and then dump the data and load it in PG via standard SQL file exports in the correct table order to avoid failures due to FK constraints. This is a gross oversimplification but you get the gist
In fact I don't get the gist :) but thanks for your reply. All I know about databases is following instructions to set one up as part of a LAMP/FAMP installation.
Prepare to be replaced by ai
Re: Stop using MySQL in 2026, it is not true open source
#30Earlier quoted context omitted.
In fact I don't get the gist :) but thanks for your reply. All I know about databases is following instructions to set one up as part of a LAMP/FAMP installation.
Prepare to be replaced by ai
haha. I have lots of other valuable skills. There's more to programming & IT than just db administration you know.