Re^2: Class::DBI vs. DBIx::Class

[hrr]

Thank you for this useful insight! An active community is worth much, so I decided to use DBIx::Class for now. Setting it up and using it turned out to be only slightly more difficult (see my stumbling above) than for Class::DBI.

[poum217]

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).

[tphyahoo]

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.

[submersible_toaster]

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.

AFAIK DBIx::Class::Schema::Loader does not automagicly figure out fk relationships (does not work for me) but I generally turn relationships off in the Loader and DWIM explicitly in the loaded classes. Check out DBIx::Class::Manual::DocMap , read it all.