in reply to Re^2: Class::DBI vs. DBIx::Class
in thread Class::DBI vs. DBIx::Class

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

Replies are listed 'Best First'.
Re^4: Class::DBI vs. DBIx::Class
by tphyahoo (Vicar) on Jun 26, 2006 at 12:20 UTC
    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.

      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.

      I can't believe it's not psellchecked