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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
