About
Hi, I’m a developer from the Netherlands, born in Brussels (Belgium) in 1976.
Married, two kids, my full name: Onno Rutger Lissenberg.
Interests:
Coding (currently a lot of PHP & Javascript) & Gaming (mostly FPS/RTS).
Did a lot of .NET coding in my prior positions.
-
Awesome, a comment on my about page! Anyway PDO is indeed experimental and thus I would not use it for something serious. The version of Doctrine we encountered had support for the standard Oracle php library but it was flawed, had to fix it first (v1.2 I think it was), see: http://ingol.nl/blog/2009/10/12/doctrine_connection_exception-pdo-connection-error-sqlstate/
p.s. At the time that we were confronted with the Oracle/Doctrine combination, we also couldn’t find useful information, had to dig down into the source code for it.
I personally prefer Zend Framework (ZF) but also use it with the standard Oracle adapter instead of the experimental PDO one. Would also choose POS (Plain Old SQL) instead of a higher level SQL dialect like Doctrine Query Language (DQL) to keep the DB code readable/maintainable for our dba-ers and more flexible (expect for simple CRUD statements, Zend_Db has nice functions for it).
-
I really thought it was a contact form xD I’m so sorry I had about 6 hours fighting with oracle (and oracle won). Anyway, thank you very much, if you wish you could move this to another page or erase the comments
I’m already reading your recomendations.
I don’t care too much about the dba, they can use the debug bar to see the results or directly learn doctrine, but working with php using only arrays is awful
Thank you again
-
Actually arrays are often easier to serialize, something we do a lot around here (e.g. a lot of JSON serialization is used for AJAX calls). Plus the developers here are coming from a Java platform which also used POS so it made the transition easier and old queries could be re-used!
We also struggled to get Oracle in place (hence see all my posts) but when you fight through the hard part it’s all fine.
You’re welcome …
Creating a better world one post at a time ;-) -
- Comment Feed for this Post
Hi Onno! I’m a PHP/MySQL developer. I found you blog searching for documentation in googlie, due that recently I start a new project that uses an Oracle 10g database (I installed the XE edition) instead of MySQL.
I use Doctrine ORM with MySQLs databases and I’d like to know if Oracle with Doctrine is stable, my doubt is because I read that PDO for Oracle is experimental and I remember that Doctrine uses PDO.
Well, if you have a site or something with documentation about it I’d really really… appreciate your help. Because I can’t find much documentation about Oracle/Doctrine.
The Oracle’s official documentation recommends Zend Core but I don’t know what’s that about
Thank you
Regards
PD: Excuse my english, I’m from Venezuela