Postgres Support?

[jazzcat]

Hello,

Has anybody tried to install OrangeHR using PostgreSQL instead of MySQL?

How much of the SQL code is MySQL specific?

Thanks,
-JC

[koshika]

Hi,

Presently OrangeHRM does employ certain MySQL specific features. Therefore it is not possible for PostgreSQL to substitute MySQL as the database in OrangeHRM.

Regards,

[jazzcat]

Presently OrangeHRM does employ certain MySQL specific features. Therefore it is not possible for PostgreSQL to substitute MySQL as the database in OrangeHRM.

Hi Koshika,

I took a look at the code, and it looks like there's a bunch of code using mysql-specific calls for standard things like connecting to the database, inserting rows, and returning query results. I couldn't find any features that are specific to MySQL. I also noted that there are mysql calls everywhere, on every page.

Many other PHP-based projects abstract all of their database calls to one library, and use something like ADODB to support many different databases. That way it's much, much easier to make these kinds of changes. I'm not sure why Orange didn't do that. Unfortunately the package is unusable in its current state for me and other companies who have existing Oracle / SQL-Server / Postgres database servers that they'd like to utilize for all applications.

Cheers,
-J

[koshika]

Hi Koshika,

I took a look at the code, and it looks like there's a bunch of code using mysql-specific calls for standard things like connecting to the database, inserting rows, and returning query results. I couldn't find any features that are specific to MySQL. I also noted that there are mysql calls everywhere, on every page.

Many other PHP-based projects abstract all of their database calls to one library, and use something like ADODB to support many different databases. That way it's much, much easier to make these kinds of changes. I'm not sure why Orange didn't do that. Unfortunately the package is unusable in its current state for me and other companies who have existing Oracle / SQL-Server / Postgres database servers that they'd like to utilize for all applications.

Cheers,
-J

Hi,

I agree with you that the Data Access classes that are written, are not in its best shape for use with other database systems. However to my knowledge the development team has indeed used MySQL specific SQL within the application. (That is what i meant by certain MySQL specific features).

We have discussed on this issue and considering refactoring into a proper data access mechanism soon.

Thanks again,

[inty.saez]

Hi Koshika:
I full agree with your comment. But, my team have been translate more than 90% (till now) of organge-2.6.0.2 features from MySQL to Postgres. I would like to know if orange community be willing to revise our work in order to share with every body our version.

Kind regards,

[Gayanath]

Hi inty.saez,

OrangeHRM code base is being changed to use Symfony framework. In version 2.6.1, You can see that Leave and Performance modules have been coded using Symfony. Once all the modules are converted to Symfony, users can change the DBMS easily since Symfony uses Doctrine ORM which a layer on top of PDO.