[Dbix-class] DBIx::Class as an Object-Relational mapper

[techwiseman-perlml at yahoo.com]

 I have been working on a proposal for my employer to restructure our customer-facing application, and am advocating an OO design.  In my research I learned a lot about the Object-Relational impedance mismatch ( http://www.google.com/search?q=Object-Relational+Impedance+mismatch ) discussed, analyzed and combated in many articles on the web.  Looking at the many issues and tradeoffs an Object-Relational mapper looks like the most acceptable alternative.  This is what led me to DBIx::Class in the first place. I have explored a few other APIs including Class::DBI, and have been a bit disappointed in the current state of DBIx::Class's documentation, but still think it's a better alternative than Class::DBI.  
 
 I do recognize that DBIx::Class and Class::DBI are both rather thin ORMs compared to other examples I've seen, and appreciate the extra control and potential added performance that would afford us. I realize that RDBMS don't really include anything that maps directly to inheritance and that any such relationships that may be represented in a database are artificial anyway.  I would still like to present such an interface to the internal object system of the application, while it would really be foreign keys and smoke and mirrors on the RDBMS side of things. I am having a little trouble understanding how to do that with DBIx::Class, and would like to see an example of such a scenario.
 
 Thank you for all your hard work, the API looks great,
 
 -Loren Osborn
  Software Engineer