Re: MediaWiki + PostgreSQL is not ready for production?

On 19/07/2016 10:20, Tatsuo Ishii wrote:
>> 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.

IMHO the way to solve this is not running to catch up with the various projects using a *SIMPLE* SQL backened, but rather create a new postgresql project providing a mysql compatibility layer,
something like a server side parser that would translate the mysql commands to real SQL (PostgreSQL) statements.
Then only one (this) project should be maintained, with no work wasted in specific client software.
So, PostgreSQL can continue to do what it knows to do best, with no worries of not being natively compatible with simplistic yet proprietary systems like mysql.
>
> 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
>
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt