Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

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

by hrr (Monk)
on Jun 25, 2006 at 16:44 UTC ( #557445=note: print w/ replies, xml ) Need Help??


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

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.


Comment on Re^2: Class::DBI vs. DBIx::Class
Re^3: Class::DBI vs. DBIx::Class
by poum217 (Initiate) on Jun 26, 2006 at 06:33 UTC
    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).
      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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://557445]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (7)
As of 2014-12-20 16:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (96 votes), past polls