Uh oh...
this post was submitted on 13 Sep 2024
1 points (100.0% liked)
Technology
59566 readers
4839 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related content.
- Be excellent to each another!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, to ask if your bot can be added please contact us.
- Check for duplicates before posting, duplicates may be removed
Approved Bots
founded 1 year ago
MODERATORS
Unpopular opinion?: without wordpress, mysql/mariadb would have died years ago.
There were so many web apps written in the early 00s on the LAMP stack, including Facebook. And that's not counting the tiny internal applications that so many businesses have that use MySQL/MariaDB. Because these are business critical applications, they pay Oracle/MariaDB for support.
Well, who is using mysql/mariadb nowadays anyways? If you haven’t made the switch to at least postgres in the past 5 years, you messed up anyways.
MySQL sucks, and almost everyone who willingly use it also sucks.
Nextcloud.
Though I think it has some level of support for postgres by now. I should check on that.
I use NextCloud w/ Postgres and it works completely fine.
Great. It wasn't too long ago that MariaDb was still the "recommended" option.
It's still "recommended" and pretty much every tutorial I see uses it, but Postgres seems to work just fine.
I just checked the docs for installation instructions, it didn't seem to make a distinction anymore.
It still is, as that’s what the developers use.
The AIO docker image put together by the NC team uses postgres. That's the recommended way to install NC now, and having used a multitude of methods in the decade I've uses nextcloud, I 100% recommend the AIO image.
Is there a minimum system requirements? I have bare metal nextcloud on a raspi 4, 4 GB ram, and it's pretty snappy.
I would consider migrating to the AIO version for more stability but IDK what toll the virtualization would take.
The virtualization shouldn't have a negative effect, since containers are just using the host kernel so it's not much extra overhead.
I would give it a try, it's simple enough to set up docker on the pi, turn off your native NC install, and add the docker compose file and stand it up. Or build another SD card with a fresh raspbian install and swap it out.
nextCloud becomes notably faster when you migrate from MySQL to PostgreSQL.
The Go version?
Are you thinking of ownCloud Infinite Scale? NextCloud is still PHP.
It's worked on Postgres for several years now, and it's the preferred and recommended backend for NC.
As someone who self-hosted it, I can't say this is true.
The MySQL or MariaDB databases are the recommended database engines.
Wordpress
Yeah the Open Source version. I doubt that the hosted version is using that. Cloud providers have super fast DB’s that are basically compatible with the MySQL syntax
There still is no documented way to migrate an existing WordPress to PostgreSQL. The PostgreSQL plugin assumes a fresh installation, everything else is not assumed to be there.
I've never heard of K1.
Should we expect MariaDB enshittification to ensure?
Strategic investment aims to accelerate MariaDB's mission to deliver innovative, scalable database solutions with new executive leadership to drive the next phase of growth
I'm not reading that as a "no" :(
Exactly. And so it begins.
MariaDB is actually two separate entities: The company MariaDB and the MariaDB organization. The company sells enterprise licenses and support, and the organization manages the actual development. So there's a little separation that will at least slow the enshittification.
Ah, good to know.
I did know there were two sides of it (we explored MariaDB Enterprise at work, but unfortunately it didn't pan out).
Any more, I just assume one company buying any other always results in a worse experience post-sale.
MariaDB tried to go public a while back and their stock price tanked immediately and never recovered. If they hadn't gotten acquired I imagine they'd have gone out of business.
How the fuck do you "accelerate" something they are already achieving?
Not sure how much of a future it can have even if you slap on some "speed".
They plan to send the mission into orbit using an North Korean missile, for maximum acceleration.
/S
So MariaDB will explode halfway to Japan?
Hummm... Can someone tell me if this is good news or bad news?
Generally a buy-out is mostly bad news, but I can't tell here in this specific case.
MariaDB.com is separate from MariaDB.org that does the development, so it shouldn't be too bad.
Then again, the folks working at MariaDB.com might have a different opinion.
Okay thank you :). We will see after a few years I guess?
It doesn't look like an "emergency alarm" to switch over to another database.
Depends. Is K1 a vulture?
Lmao he did it again
Hope he got another kid to name that next fork after.
I hope this won’t have any negative effects on PostgreSQL which will hopefully not have to cater the MySQL refugees now.
I am a bit out of the loop in terms of RDBMS history, what do you mean by MySQL refugees?
MySQL refugees = those who ran to MariaDB when MySQL was bought by 'Orrible and now need another new home. Accidentally, PostgreSQL has grown support for some of MySQL on recent versions.
Oracle is such a terrible company for their customers it makes a ton of sense to try to get them to switch to a less abusive company
My coworker used to work with Oracle at his last job, and he took an architect position at my company near the start of development. There's a reason we use Postgres at our org...
Some of our customers rely on Oracle’s database system, because history. Sadly, we can’t teach them.
True, and I keep those folks in my prayers.
But if you're on MySQL it's a lot less of a lift to switch to MariaDB than it is to go to Postgres, even if Postgres is better in some ways.
I rewrote the last remaining MySQL-based software of mine this year because I didn’t want to have MariaDB just for this one tool. Everything else had already been migrated. PostgreSQL is much faster in my tests.
Good news in furthering Postgres adoption I guess. I mean most stuff was going that way anyway, but this will likely speed things up.
If you needed a reason to switch to Postgres, there you go.