On 19/07/2016 12:05, Tatsuo Ishii wrote:
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.
I'm not sure that's the best way ever. Sometimes the approach results
in lesser performance of PostgreSQL than MySQL because of the SQL is
not optimized for PostgreSQL. For toy project, that's fine. But for
serious project it might bring bad performance and users will be
disappointed and speak like "PostgreSQL is slower than MySQL". I saw
that with Zabbix, for example.
Better to run, even slowly, than not run at all, or require special porting
team for every mysql client out there.
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
