One more thing on Class::DBI (I don't know if it exists for DBIx::Class) : Class::DBI::Loader. This module waits for database access parameters and give instant access to all database table as Class::DBI objects. More, relation between all this objects (by foreign keys) are also available. A great lesson of lazyness leading to very small code (using Template-Toolkit for the view part in web development).
Re^3: Class::DBI vs. DBIx::Class
Replies are listed 'Best First'.
DBIx::Class::Schema::Loader is relatively new, and purports to do something similar to Class::DBI::Loader. I haven't tried it, but it judging by postings on the catalyst newsgroup, it seems to be getting popular. I'm not sure if it does foreign keys. It's not mentioned in the pod, so I guess not... but on the other hand, fk relationships aren't mentioned in the pod for Class::DBI::Loader either.
Whatever the case, DBIX schema loader is under active development, so if there's not fk support already, maybe sometime soon.
Since playing with DBIx::Class and related also within (as mentioned above) Catalyst and on it's own , I am seriously considering it for new projects and _almost_ tempted to port existing work over to DBIx::Class from Class::DBI.