On 2020-01-29 11:44, Alberto Abrao wrote:
> I am in the process of rebuilding my Nextcloud setup.
>
> My current one uses MariaDB, which is the recommended one by
> NextCloud. I had a few issues that needed database repair since then,
> but other than that it works fine.
>
> That said, as I am going to do it all from scratch - my aim is to set
> it up integrated with e-mail - I was wondering if I should use
> PostgreSQL instead.
>
> I know nothing at all about databases, so I was wondering if one - or
> many - of our wise fellows here could chime in and give an informed
> opinion on the matter.
>
> Thanks!

The $0.10 overview is:

* PostgreSQL is a much more capable database, adheres more closely to
standards, and has features MySQL/MariaDB/etc can only dream of.  But
it's a bit of a pain to run in production.

* MySQL/MariaDB comes from a really crappy starting place, so all the
nice features are bolt-ons, and there's lots of legacy technical debt. 
On the other hand, it's mostly fire-and-forget, and Every. Single.
Application. out there supports MySQL and has instructions or a HOWTO
for it.

YMMV.  Use whichever database your app supports best, unless you have a
compelling need to change.

-Adam
_______________________________________________
Roundtable mailing list
Roundtable@muug.ca
https://muug.ca/mailman/listinfo/roundtable