Nextcloud recommends MySQL/MariaDB, but supports PostgreSQL as well.
Well, if I am to live on the edge, might as well do it on my own stuff.:D
So yes, I decided to go with PostgreSQL this time, and so far I don't regret it. I was getting a ton of database error messages with MariaDB. So far, absolutely zero with PostgreSQL.
I will, of course, let everybody know if that ever changes.
Thank you Adam and John for chiming in!
Kind regards, Alberto Abrao 204-202-1778
On 2020-01-29 5:33 p.m., John Lange wrote:
Adam, you could have saved $0.08! Your $0.02 summary "Use whichever database your app supports best" is right on the money!
John
On Wed, Jan 29, 2020 at 12:28 PM Adam Thompson <athompso@athompso.net mailto:athompso@athompso.net> wrote:
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 <mailto:Roundtable@muug.ca> https://muug.ca/mailman/listinfo/roundtable-- John Lange
Roundtable mailing list Roundtable@muug.ca https://muug.ca/mailman/listinfo/roundtable