- #Mysql vs postgresql vs mariadb vs oracle how to#
- #Mysql vs postgresql vs mariadb vs oracle install#
- #Mysql vs postgresql vs mariadb vs oracle code#
- #Mysql vs postgresql vs mariadb vs oracle free#
NC17 release screenshots show a new section titled "Two-factor admin" between the "Password Policy" and "Oauth 2.0 Clients" sections. I upgraded our company to NC17 and that section of the "Security" settings just isn't there.
#Mysql vs postgresql vs mariadb vs oracle code#
I got really excited for NC17 when I saw one of the new features involved support for an admin generated single use 2FA code to help users who were locked out of their account. Looking through the forum exchanges on this, since this is not an "Official" Nextcloud app (even though Christoph works for Nextcloud) it is a "low-priority" issue. It doesn't work unless you're using MySQL or SQL-Lite. But for the last few versions I've been running into a problem w/ the 2-factor admin tool written by Christoph Wurst. I installed Nextcloud from a prepackaged VM image and the database of choice was PostgreSQL. It would really be nice if there was more clarity on this issue. I'm also open for suggestions if you want me to improve it before you post it.
#Mysql vs postgresql vs mariadb vs oracle free#
Feel free to retweet or even post it on the Nextcloud blog if you don't feel it's to harsh or something like that. So that's why I made this post, to encourage you to do some more tests with PostgreSQL and maybe, just maybe notice the same things as I did.ĭisclaimer I have not tested in clustered or bigger environments than 320 Writing a blog post as we speak. Most of the apps work with PostgreSQL but some don't and a warning pops up that it's only working with.
Nevertheless, I'm grateful that Nextcloud supports PostgreSQL but recommending a database also mean that app developers won't bother to support the alternative if they don't have to. Maybe "feel" was the wrong word, maybe I should say -^ instead. I will not fight you about this and it's not my intention to waste your time or anything like that, but again I've done a lot of reading and testing since I now also maintain a PostgreSQL VM and I can say from my own experience that have noticed that PostgreSQL is faster, easier to setup (at least I think as it's fewer lines of bash commands), more secure, and a more advanced database in general. That might explain why it worked better than PostgreSQL.
#Mysql vs postgresql vs mariadb vs oracle how to#
It's quite obvious to me that MySQL MariaDB is recommended because most of the Nextcloud devs are familiar with it, and because of that also have better knowledge in how to set it up. That's also why I now, after I tested it myself, will recommend PostgreSQL rather than something else. Like I recommend Nextcloud instead of ownCloud because I think that Nextcloud is the better choice. Of course you tend to recommend something that you are more familiar with and can support in a better way than the alternative. That proves to me that the choice is quite personal for you as well. According to several hours of reading I did comparing and testing the alternatives. There are a lot to gain in using PSQL any other DB IMHO. Maybe you should consider making PostgreSQL the recommended DB after all?Īlso, this is not just about UTF8mb4, I'm talking generally. Also UTFmb4 is considered "experimental" according to docs which isn't the case with PostgreSQL as it just works out of the said that MariaDB/MySQL was performing better when tested in a clustered environment, but my guess is that that test was some time ago. According to the IRC channel (#posgresql) UTF8mb4 is just something that MariaDB/MySQL came up with becuase they messed up the original code and had to make a quick fix to solve it.
#Mysql vs postgresql vs mariadb vs oracle install#
I'm writing this after I have been messing with MariaDB for hours to activate 4 byte support, which only took a few minutes in PostgreSQL (aka apt install postgresql).
Would be nice if Nextcloud decided to go down that path instead of recommending a less advanced (and IMHO) worse DB. PostgreSQL feels like a better DB in general. In MariaDB/MySQL you have to mess around with UTF8mb4 if you want 4-byte support, which is default in PostgreSQL UTF8. I wish PostgreSQL in general was better supported.
0 kommentar(er)
