Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re: Class::DBI vs. DBIx::Class comparison

by Your Mother (Archbishop)
on Jul 26, 2008 at 20:16 UTC ( #700315=note: print w/replies, xml ) Need Help??

in reply to Perl ORM comparison (Class::DBI vs. DBIx::Class vs. Rose::DB::Object)

Preface with: I was long a fan of CDBI and would still use it for simple scripts like an an inlined SQLite CGI or such; the last time I did use it was for a standalone poll script.

While you say, "Mature and stable code," for CDBI, note that it has a few times been unstable with minor version to version changes breaking compatibility.

The results set stuff for DBIC is very powerful. And though the syntax is harder to master you will find that anything non-trivial with CDBI starts to require contortions, redundancy, and spaghetti. DBIC is a much deeper/cleaner design and much less likely to let you down on the edge cases that real sites/projects are riddled with.

Also, it's been awhile so I'm not sure how true this is now but in the past CDBI was quite a bit slower. Speaking of which, if speed is important, Rose is the speed winner.

Update: DBIx::Class beats Rose on some metrics now (there was a huge refactor in 20132014). I would no longer consider using Class::DBI for anything at all.

  • Comment on Re: Class::DBI vs. DBIx::Class comparison

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (2)
As of 2021-12-01 03:29 GMT
Find Nodes?
    Voting Booth?

    No recent polls found