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 2013–2014). I would no longer consider using Class::DBI for anything at all.
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||