The system requirements page lists the supported databases:
- MySQL 5.7+ or MariaDB 10.2+ (recommended)
- Oracle Database 11g (only as part of an enterprise subscription)
- PostgreSQL 9.5/9.6/10/11
- SQLite (only recommended for testing and minimal-instances)
What is the rationale behind recommending MySQL?
- Does Nextcloud work better with MysQL/MariaDB? If yes, what specifically?
- Is MySQL just the most “popular” and therefore recommended?
I have been using PostgreSQL and Nextcloud for years and didn’t encounter any problems. In fact, IMHO PostgreSQL is superior because it is usually more hassle-free and supports more convenient SQL-Syntax while MySQL seems to be a little bit cobbled together. While developing the user_backend_sql_raw app, I found that the code for PostgreSQL was simple and straight forward but I had to add several workarounds and ugly hacks for MySQL.
I don’t want to start a flame war, but I am genuinly curious why new users are pushed into the MySQL path.