[RndTbl] PostgreSQL vs MariaDB
Alberto Abrao
alberto at abrao.net
Tue Feb 4 10:21:49 CST 2020
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 at athompso.net
> <mailto: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 <mailto:Roundtable at muug.ca>
> https://muug.ca/mailman/listinfo/roundtable
>
>
>
> --
> John Lange
>
>
> _______________________________________________
> Roundtable mailing list
> Roundtable at muug.ca
> https://muug.ca/mailman/listinfo/roundtable
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://muug.ca/pipermail/roundtable/attachments/20200204/b19eff1d/attachment.htm>
More information about the Roundtable
mailing list