Forums / Developer / eZ and Oracle
Marko Žmak
Wednesday 02 June 2010 3:42:04 am
In my quest for the (holly grail) answer to the question "Exponential or Drupal?" I came accross this article:
http://www.oracle.com/technology/pub/articles/pedros-drupal.html
So I'm interested how would eZ deal with the issues described there, especially those pointed out in the "Where Are We Now?" chapter.
-- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth
Gaetano Giunta
Wednesday 02 June 2010 1:51:54 pm
Last time I checked (around 2007 iirc), drupal had no db-access-layer at all. There was some chat going on about adding oracle support, but it was not a trivial task. The blog linked from the article you mention is dead...
On the eZ side:
Or where you asking for real technical aspects of creating a cms that is portable between dbs? That would take a much longer answer... The starting point to gleam some info would be to look into the code of the ezoracle extension. But I might have laying around a slide set used to teach oracle-style to mysql coders if you are interested.
Principal Consultant International Business Member of the Community Project Board
Chen Xiongjie
Thursday 03 June 2010 12:43:22 am
LOL.:)
we have one of the most talented oracle coders in the php community, who matured experience participating to the adodb project, too (in case you do not get the joke: it's me!)
In addition, eZ has Oracle unit test support from this last alpha version(4.4.0 alpha2).
--
Chen
eZ Comments: http://projects.ez.no/ezcomments twitter: http://twitter.com/xiongjie
Bertrand Dunogier
Thursday 03 June 2010 1:35:52 am
While it is true that our oracle implementation is now well tested and supported, I think some of the issues raised in the linked article can't be ditched just like that.
The platform-neutral SQL part is one we have already discussed many times. Having an SQL language abstraction is one thing, data models and how each database is best used indeed is a complex matter. While our implementation works, and works fine, there is no doubt that the database schema isn't really optimized for Oracle. RDBMS "custom" features are mentioned here, and the abstraction indeed doesn't let us benefit from most of these specificities.
Regarding the database structure and oracle specific implementations, I think Gaetano has covered this up pretty correctly, thanks to his huge experience with oracle. There probably is room for improvement, but I think we're on the right track here.
Any comments on these specific points ?
Bertrand Dunogier eZ Systems Engineering, Lyon http://twitter.com/bdunogier http://gplus.to/BertrandDunogier
Yannick Modah Gouez
Monday 30 May 2011 6:42:24 am
I never heard of that feature, could you please tell us more about it ?