|Syntactic Confectionery Delight|
Class::DBI vs. DBIx::Classby hrr (Monk)
|on Jun 24, 2006 at 21:08 UTC||Need Help??|
hrr has asked for the
wisdom of the Perl Monks concerning the following question:
Class::DBI and DBIx::Class both seem to be very nice modules for accessing relational databases in an object-oriented way. Both modules look rather similar and it is hard for me to decide which one I should use. It would be great, if you could advise me on this decision---generally I would prefer the more robust and stable solution.
So far, I tried to use Class::DBI and DBD::DB2 on ActivePerl. This works for fine for SELECTs; however, insert() does not work for some reason (Can't locate object method "insert"). When I use DBD::CSV, insert works. Alternatively, I could use perl on cygwin (but I have to find out how to compile DBD::DB2 there). Hints on this problem would also be appreciated!
Update: Thanks for all these helpful comments! To summarize, the options are the following: