PostgreSQL vs MariaDB
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! -- Kind regards, Alberto Abrao 204-202-1778 204-558-6886
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
I second Adam's sentiments. Also if you don't have multiple concurrency use case... which unfortunately NextCloud seems to desire. SQLite is pretty fantastic and requires no infrastructure. These days there are so many options. -----Original Message----- From: Roundtable <roundtable-bounces@muug.ca> On Behalf Of Adam Thompson Sent: January 29, 2020 12:28 PM To: Continuation of Round Table discussion <roundtable@muug.ca> Subject: Re: [RndTbl] PostgreSQL vs MariaDB 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
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
-- John Lange
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
participants (4)
-
Adam Thompson -
Alberto Abrao -
John Lange -
Sean Cody