12/18/2023 0 Comments Postgresql vs mysql performance 2016![]() ![]() ![]() As a database engine we do use it in a load balanced setup as part of a bussiness intelligense solution at work (and not for Nextxloud) so I know for a fact that it can also work in an enterprise and High performance environment. I am looking on this from an easier to manage and support perspective - for both enterprise and community. ![]() I am in no position to state or know or even suggest, which database system is most comfortable for the Nextcloud GmbH developers. In a “business” world - doesn’t need to be enterprise - start with a school or NGO - in my eyes it’s no-go to ship an app which doesn’t support everything the base system does… In may exes the project has grown out of the the “let’s code something cool” phase into the “we want play in the same league as Microsoft and Google” as with such positions another user base is attracted and expectation rise with them… There are lot of examples when it works good or bad… the question what is the right way for Nextcloud. Serious developer must be prepared to add functionality he doesn’t require and maybe doesn’t like just to make users happy. Your never know the motivation of the dev but it’s really easy to start a project, implement some cool functionality, cover own requirements and forget it. Start with an official parts like E2E encryption or mail app - I’m pretty sure E2E still lacks basic functionality like sharing “introduced” 2016 (?) and mail app despite heavy advertising and likely many development efforts still can’t compare with Rainloop/Snappymail… Maybe this is a non-issue at all, as we only know 2 apps which are such bad to miss this simple criteria… but in Nextcloud we have in general far too many good unfinished ideas. My preference is definitely towards few good apps rather lot of broken. ![]() In case the dev is not willing to support 3 PHP versions and 3 databases I likely prefer not to have such app in the store. They do some testing based on their setup, if you force them to test all the imaginable combinations of different php/database whatever version, they just won’t publish it. I was just wondering if switching to Postgresql recommendation instead of MariaDB, would canabalize some on the enterprise subscriptions, as high availability would suddently be much easier to obtain without the need for enterprise license? Add the powerfull support for nosql like JSON datastorage aswell as both XML and JSON syntax support. Features which mariaDB needs a Galea cluster in front to solve. Other stuff offered by Postgresql is much better support of multitenant SQL cluster in load balancing and caching of SQL for not-yet replicated data. Some of these - like how they made support for bigint - is sometimes causing troubles for nextcloud installations. However MariaDB is a fork of the MySQL project when it was still open source. I say this not to start the almost religious debate between those in favour of MariaDB vs those in favour of Postgresql. In fact I would not bat an eye if they switched to Postgresql as default recommended database engine. I am wondering why Nexrcloud is recommending MariaDB over Postgresql. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |