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

Technology

59605 readers
3501 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
you are viewing a single comment's thread
view the rest of the comments
[–] earmuff@lemmy.dbzer0.com 14 points 2 months ago (21 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.

[–] MentalEdge@sopuli.xyz 9 points 2 months ago* (last edited 2 months ago) (4 children)

Nextcloud.

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

[–] sugar_in_your_tea@sh.itjust.works 15 points 2 months ago (2 children)

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

[–] MentalEdge@sopuli.xyz 6 points 2 months ago (2 children)

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

[–] sugar_in_your_tea@sh.itjust.works 6 points 2 months ago (1 children)

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

[–] MentalEdge@sopuli.xyz 2 points 2 months ago

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

[–] tux0r@feddit.org 5 points 2 months ago (1 children)

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

[–] ikidd@lemmy.world 4 points 2 months 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.

[–] sem@lemmy.blahaj.zone 1 points 2 months 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.

[–] ikidd@lemmy.world 2 points 2 months 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.

[–] tux0r@feddit.org 2 points 2 months ago

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

[–] ikidd@lemmy.world 2 points 2 months ago (1 children)

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

[–] rolling_resistance@lemmy.world 5 points 2 months 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

[–] ikidd@lemmy.world 1 points 2 months 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.

[–] earmuff@lemmy.dbzer0.com 1 points 2 months ago

My question was ironic, implying that anyone using it in a productive system/software/service is doing a very bad job at software architecture. I avoid any product relying on super slow software pieces.

[–] eleitl@lemm.ee 1 points 2 months ago (1 children)
[–] sugar_in_your_tea@sh.itjust.works 2 points 2 months ago (1 children)

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

[–] eleitl@lemm.ee 1 points 2 months ago

Ah, yes. Thanks.

load more comments (16 replies)