DB Gateway generators?
Posted: Fri Mar 05, 2010 11:31 am
I am not a fan od ORM, mostly because my current gateway API consist of some fairly interesting SQL which would probably be difficult to easily express (or do at all) in ORM. I just find it easier to hammer out the SQL by hand and make it dynamic as required.
Of course this means a lot of similar code (especially in CRUD) and while I could use a trivial data mapper/AR to simply much of this SQL generation, there is the issue of consistency for me, having some code use direct SQL and others still use various data objects, just bugs me.
I'm looking for a tool that lets me build a database schema, specify relationships and maybe even the API of the gateway and have the software automgaically generate the gateway API for me, so I basically program the gateway code using a interface like phpMyAdmin or Drupal CCK/Views and voila. The output is optimized generated SQL hidden behind a interface which I can easily use throughout my applications.
I've toyed with some ideas myself but the project is not trivial and I would prefer something ASAP, so I figured I would ask and see what or how you replied.
Not looking for Doctrine, Propel, phpDataMapper, etc type solutions. Thanks
Cheers,
Alex
Of course this means a lot of similar code (especially in CRUD) and while I could use a trivial data mapper/AR to simply much of this SQL generation, there is the issue of consistency for me, having some code use direct SQL and others still use various data objects, just bugs me.
I'm looking for a tool that lets me build a database schema, specify relationships and maybe even the API of the gateway and have the software automgaically generate the gateway API for me, so I basically program the gateway code using a interface like phpMyAdmin or Drupal CCK/Views and voila. The output is optimized generated SQL hidden behind a interface which I can easily use throughout my applications.
I've toyed with some ideas myself but the project is not trivial and I would prefer something ASAP, so I figured I would ask and see what or how you replied.
Not looking for Doctrine, Propel, phpDataMapper, etc type solutions. Thanks
Cheers,
Alex