this post was submitted on 13 Sep 2024
117 points (97.6% liked)

Technology

59174 readers
2961 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots


founded 1 year ago
MODERATORS
top 50 comments
sorted by: hot top controversial new old
[–] [email protected] 68 points 1 month ago* (last edited 1 month ago) (3 children)

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" :(

[–] [email protected] 42 points 1 month ago (1 children)

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.

[–] [email protected] 10 points 1 month ago (1 children)

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.

[–] [email protected] 7 points 1 month ago

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.

[–] [email protected] 12 points 1 month ago

Exactly. And so it begins.

[–] [email protected] 6 points 1 month ago* (last edited 1 month ago) (2 children)

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".

[–] [email protected] 1 points 1 month ago (1 children)

They plan to send the mission into orbit using an North Korean missile, for maximum acceleration.

/S

[–] [email protected] 2 points 1 month ago

So MariaDB will explode halfway to Japan?

[–] [email protected] 1 points 1 month ago

Hopefully it means more people working on it. But honestly, I use Postgres, so it doesn't particularly matter to me what "accelerate" means for them.

[–] [email protected] 18 points 1 month ago (1 children)
[–] [email protected] 8 points 1 month ago (1 children)

Hope he got another kid to name that next fork after.

[–] [email protected] 1 points 1 month ago (1 children)

He does!

Say hello to MaxDB!

[–] [email protected] 14 points 1 month ago (3 children)

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.

[–] [email protected] 11 points 1 month ago (1 children)
[–] [email protected] 1 points 1 month ago (1 children)

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

[–] [email protected] 2 points 1 month ago

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.

[–] [email protected] 9 points 1 month ago* (last edited 1 month ago) (4 children)

Nextcloud.

Though I think it has some level of support for postgres by now. I should check on that.

[–] [email protected] 15 points 1 month ago (2 children)

I use NextCloud w/ Postgres and it works completely fine.

[–] [email protected] 6 points 1 month ago (2 children)

Great. It wasn't too long ago that MariaDb was still the "recommended" option.

[–] [email protected] 6 points 1 month ago (1 children)

It's still "recommended" and pretty much every tutorial I see uses it, but Postgres seems to work just fine.

[–] [email protected] 2 points 1 month ago

I just checked the docs for installation instructions, it didn't seem to make a distinction anymore.

[–] [email protected] 5 points 1 month ago (1 children)

It still is, as that’s what the developers use.

[–] [email protected] 4 points 1 month ago (1 children)

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.

[–] [email protected] 1 points 1 month ago (1 children)

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.

[–] [email protected] 2 points 1 month ago

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.

[–] [email protected] 2 points 1 month ago

nextCloud becomes notably faster when you migrate from MySQL to PostgreSQL.

[–] [email protected] 2 points 1 month ago (1 children)

It's worked on Postgres for several years now, and it's the preferred and recommended backend for NC.

[–] [email protected] 5 points 1 month ago (1 children)

As someone who self-hosted it, I can't say this is true.

The MySQL or MariaDB databases are the recommended database engines.

https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/linux_database_configuration.html

[–] [email protected] 1 points 1 month ago

Huh. I figured they changed to PG since that's what their AIO image is using, and having used both myself in regular baremetal installs, postgres is by far the better performing backend.

[–] [email protected] 1 points 1 month ago (1 children)
[–] [email protected] 2 points 1 month ago (1 children)

Are you thinking of ownCloud Infinite Scale? NextCloud is still PHP.

[–] [email protected] 1 points 1 month ago

Ah, yes. Thanks.

load more comments (1 replies)
load more comments (1 replies)
[–] [email protected] 10 points 1 month ago
[–] [email protected] 10 points 1 month ago (1 children)

Unpopular opinion?: without wordpress, mysql/mariadb would have died years ago.

[–] [email protected] 18 points 1 month 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.

[–] [email protected] 6 points 1 month ago

Good news in furthering Postgres adoption I guess. I mean most stuff was going that way anyway, but this will likely speed things up.

[–] [email protected] 5 points 1 month ago (2 children)

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.

[–] [email protected] 12 points 1 month ago (1 children)

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.

[–] [email protected] 3 points 1 month ago* (last edited 1 month ago)

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. However, I was already thinking of switching every container to postgres. Maybe that's the push needed.

[–] [email protected] 2 points 1 month ago

Depends. Is K1 a vulture?

[–] [email protected] 2 points 1 month ago

If you needed a reason to switch to Postgres, there you go.

[–] [email protected] 1 points 1 month ago (1 children)

I hope this won’t have any negative effects on PostgreSQL which will hopefully not have to cater the MySQL refugees now.

[–] [email protected] 5 points 1 month ago (1 children)

I am a bit out of the loop in terms of RDBMS history, what do you mean by MySQL refugees?

[–] [email protected] 10 points 1 month ago (1 children)

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.

[–] [email protected] 10 points 1 month ago (2 children)

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

[–] [email protected] 6 points 1 month ago

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...

[–] [email protected] 5 points 1 month ago (1 children)

Some of our customers rely on Oracle’s database system, because history. Sadly, we can’t teach them.

[–] [email protected] 4 points 1 month ago (1 children)

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.

[–] [email protected] 3 points 1 month ago

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.

load more comments
view more: next ›