As part of a university project, I've got to build a web application to display information coming from an Oracle database. I've already used FuelPHP for different projects and really like it.
Will the PDO in FuelPHP work directly with Oracle? Do I only need to modify the connection array in development.php (or production.php) to use "oci:dbname" instead of "mysql:host" + the relevant connection info to be able to use FuelPHP with Oracle?
The PDO driver is basically standard PDO. Afaik that works with the correct Oracle drivers, so I don't think Fuel would have a problem with it. The DSN in the config is the standard PDO DSN.
There are some bits added so that it tries to return the insert id on an INSERT, which might or might not be working, you'll have to see.
DButil is at the moment pretty MySQL centric, so that will probably not work.
Let us know how you get on, and if Oracle needs specific treatment.
For 2.0, we're going to replace the current DB layer with a new one that will be platform aware, so instead of a generic PDO driver you will have a PostgreSQL driver and an Oracle driver (which we don't have yet, hence my interest ;))
I'll probably connect the site to the Oracle DB in a couple of weeks. Before filling the DB there's a whole ETL process to go through and the university closes for a week.
Donate
