Re: MediaWiki + PostgreSQL is not ready for production?

> On 7/18/2016 9:14 PM, Tatsuo Ishii wrote:
>> I found following comment for using PostgreSQL with MediaWiki:
>>
>> https://www.mediawiki.org/wiki/Compatibility#Database
>>
>> "Anything other than MySQL or MariaDB is not recommended for
>> production use at this point."
>>
>> This is a sad and disappointed statement for us. Should we help
>> MediaWiki community to enhance this?
>
> the classic problem with any of these sorts of open source projects,
> while you can convert the core system to postgres, there's a huge
> community of contributed plugins, and many of these authors have zero
> interest in anything but their default database, mysql/mariadb. I ran
> into this with Drupal, Wordpress, a couple different forum projects.
> Drupal even tried to offer a database API so plugin developers
> wouldn't touch SQL directly, but too many ignored it.

Yeah, that's a classic problem. The reason why I raise the particular
problem was, I hoped situations were better with MediaWiki since it
has been used for PostgreSQL official site. But the truth is even
MediaWiki is not an exception.

My colleague has been working on making the latest version of WordPress
work with PostgreSQL (there used be a PostgreSQL plugin but it has not
been maintained and does not work with the latest version of
WordPress). I imagine there are someone who are attacking the classic
problem and I wonder as PostgreSQL community, what we can do for this.

This may not be the brightest idea but what about starting with
creating wiki page listing such that works? This will help users who
want to use PostgreSQL with WordPress, MediaWikim Drupal etc. (and
many plugins).

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp