Zoph

I have checked in a change to Zoph where all the database calls are grouped
in one file: database.inc.php, it should now be possible to change all the
"mysql" keywords to "oci" (the PHP Oracle Interface) to make Zoph talk to
an Oracle DB.

You should also change mysql to Oracle in zophImport.pl.

I have know idea whether Oracle will take all the queries Zoph uses. Some
things you definately want to test is the search page, which uses
dynamically built queries and the access rights for a non-admin users, the
queries that are used by that are way more complex than the queries used by
an admin-user.

Please let me know whether you can get this to work, if you need to make
adjustments to other parts of Zoph or if you need other help.

Hello,

we ( a public hospital ) use Oracle for many other applications and have
two employees here that know oracle very well. We have postgres too and I
don't want other db's if possible.

I did not look at your source code, so I don't know how abstracted the db
code is. If it is not, so http://pear.php.net/package/DB would be a good
starting point to make Zoph independent from a specific DB

Happy New Year
Andreas

Perl DBI is only used in zophImport.pl / zophExport.pl, the rest of Zoph is
written in PHP. I am not sure whether Oracle will understand the queries
I'm currently feeding MySQL and I do not have an Oracle system to test
against. One thing I will do in the near future is moving all the
mysql-calls, that are currently scattered around the source into a single
function, which will make changing to a different DB easier.

Why would you want to use Oracle? MySQL is probably not feasable for all
tasks, I think it fits the needs Zoph has quite good.