In this proposal I bring a topic that I would like not to fall into oblivion, it's about PostgreSQL support, a topic that was left in the archive (flarum/issue-archive#411) and there was a lot of interest in it.
Recently I have seen some projects that I follow that have started their efforts to migrate/make PostgreSQL compatible, like one that I follow closely which is Wiki.js, where a while ago they made the decision that in the next major release (3.0) they will be PostgreSQL compatible only (https://blog.js.wiki/news/2021/wiki-js-3-going-full-postgresql) the analysis although brief seems to me quite accurate, I think Flarum could at least be starting a similar path, adding soon PostgreSQL support officially (
without being a breaking change) and keeping MySQL and MariaDB support for quite some time like Wiki.js did, to later probably go to a complete switch and therefore have a fairly smooth migration.
Personally this is something I would really like to do as I maintain other applications that use PostgreSQL, so it results in double the efforts of maintaining both database engines and I guess I'm not the only one.
So I would like to take this opportunity to ask if currently Flarum without making changes (although it's undocumented) it's possible to use PostgreSQL?