[RndTbl] PostgreSQL vs MariaDB

[John Lange]

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


-- 
John Lange
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://muug.ca/pipermail/roundtable/attachments/20200129/1a81315f/attachment.htm>