PostgreSQL

arjunrk wrote on Thursday, February 19, 2015:

Hi,
I am new to openEMR, and i just want to change the the DB from mySQL to PostgreSQL. is it possible in any way…?

fsgl wrote on Thursday, February 19, 2015:

Practically all of the install manuals suggest using MySQL.

Using something else may introduce incompatibilities.

For my part, I don’t have the background to understand Things to find out about when moving from MySQL to PostgreSQL. Be certain that you do.

sunsetsystems wrote on Thursday, February 19, 2015:

It would be a big job. A good first step would be to refactor the code to an object oriented data model.

Rod
http://www.sunsetsystems.com/

epicstar wrote on Monday, February 23, 2015:

I’ve done some of this before (mysql -> postgresql). It’s possible but you’d have to change the statements within the PHP since some of the SQL syntax is a little different. I wouldn’t recommend it unless you want to fork the project to your own.