LMCE runs MySQL as its database server. I have an existing Postgres installation, and I'd rather not DBA two different databases. The PHP scripts seem to use ADO to connect to the DB, which might mean only the datasource has to be changed, but that's usually just wishful thinking. And there's lots more glue than in the PHP.
I see that there is a documented technique for distributing the MySQL server across the network, rather than running on the core localhost
. But it seems untested, and just a hint at using a different RDBMS entirely.
Has anyone investigated or documented what it would take to port LMCE from MySQL to Postgres? Any notes on any dependencies of LMCE on MySQL specifically, either SQL syntax, or features, or some other constraint? OTOH, is anyone running LMCE on Postgres already?