For several reasons, I am in strong favour of using MySQL instead of PostgreSQL for hosting OpenPetra.
Here they are:
- At TBits.net, we have a lot of experience with MySQL. Optimizing the query speed with caches, etc.
- Loading the initial database (
nant recreateDatabase) is faster, because foreign keys can be created at the time when the table is created, even if the other table does not exist yet.
- Database upgrades are easier, you can add new columns at a specified place, not just at the end of the list.
Since OpenPetra is written to support multiple database backends, this should not cause much trouble, but rather increase the quality for all supported database systems (PostgreSQL, SQLite, MySQL/MariaDB) overall.
