[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