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 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 https://muug.ca/mailman/listinfo/roundtable