koshika wrote:Presently OrangeHRM does employ certain MySQL specific features. Therefore it is not possible for PostgreSQL to substitute MySQL as the database in OrangeHRM.
jazzcat wrote: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.
Users browsing this forum: No registered users and 2 guests