- cross-posted to:
- [email protected]
- cross-posted to:
- [email protected]
You must log in or # 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.
See also duckdb and clickhouse for OLAP of course.
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?
Perhaps MariaDB is a better choice.
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
MariaDB
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’.
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
deleted by creator
People have hated Oracle for decades.
The hell did Oracle do?
Have you been living under a rock? Think 2010 for starters…
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.
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
You forgot what they did to Java, plus they sued Google for using Java API.
If you don’t want to use postgresql for some obscure reason use MariaDB real open source MySQL drop in replacement.
What rock do you live under if you’re using MySQL over MariaDB?
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.
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
LAMP indeed
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.
Apache Phoenix: allow me to introduce myself
Who?
Apache Phoenix
Looks great for my blog!
