- cross-posted to:
- technology@lemmy.world
- cross-posted to:
- technology@lemmy.world
You must log in or register to comment.
No one should be using MySQL since 2010.
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?
What year is this? No one should be using Mysql since MariaDB came about.
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
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.
afaik MariaDB is the open source version of MySQL
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.
What rock do you live under if you’re using MySQL over MariaDB?
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.
It used to be free with less of a barrier to entry than postgres
Tutorials mostly.
LAMP indeed
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.
Stop using mysql, you have postgres.
And mariaSQL
FWIW mariadb was bought by a private equity firm in 2024
Hell, even SQLite is good enough for most small projects.
MariaDB >>>
I’ve been using it since ever on my rpi because they say it’s easier on resources
