<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:tahoma,new york,times,serif;font-size:12pt">I didn't consider the lazy attribute population a weakness - it can come in handy when processing large numbers of records with lots of columns - it helps reduce memory bloat., and besides I'm pretty sure it can be overridden. <br><div> </div>---<br>Mark Mertel<br>mark.mertel@yahoo.com<div><br></div><div style="font-family: tahoma,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Colin Meyer <cmeyer@helvella.org><br><b><span style="font-weight: bold;">To:</span></b> Michael R. Wolf <MichaelRWolf@att.net><br><b><span style="font-weight: bold;">Cc:</span></b> SPUG Members <members@seattleperl.org><br><b><span style="font-weight:
bold;">Sent:</span></b> Mon, February 15, 2010 11:19:17 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: SPUG: REMINDER February 2010 Seattle Perl Users Group (SPUG) Meeting<br></font><br>
On Mon, Feb 15, 2010 at 08:35:53AM -0800, Michael R. Wolf wrote:<br>><br>> On Feb 15, 2010, at 6:56 AM, Andrew Sweger wrote:<br>><br>>> Remember, DBIx::Class at SPUG tomorrow evening. Details below...<br>><br>> Currently using Class::DBI on a current project, I sure would be <br>> interested in how folks might compare the two. I don't think that <br>> swapping one out for the other is appropriate, but knowing folks' <br>> experience with both would help on future projects.<br><br>Class::DBI is old, crufty and un-maintained. There's a compatibility<br>plugin, DBIx::Class::CDBICompat, which will help you transition to<br>DBIx::Class. You'll still suffer some of CDBI's weaknesses, like all the<br>slowdown from lazy loading.<br><br>If you would like to use a Perl ORM, then DBIx::Class has the biggest<br>and most active community. Rose::DB is another reasonable choice. I<br>believe that it is faster than
DBIC.<br><br>Personally, I waffle back and forth quite a bit on the overall<br>usefulness of ORMs. They make simple things very quick. But has anyone<br>used any ORMs that make the maintain complex queries easy? Writing and<br>maintaining complex queries in DBIC make me want to shoot myself. I find<br>myself desperately wishing for a domain specific language that's handily<br>designed for information retrieval from relational databases. Oh yeah,<br>there's this thing called SQL ...<br><br>I do like writing a complex query in SQL, and hiding that in a db view.<br>Then I can use DBIC for simple queries against the view, and get some<br>benefits, like paging, for making quick web based db reports. But then<br>try to make a report that rolls columns up together, or anything fancy,<br>and this simple scheme becomes unwieldy.<br><br>-Colin.<br>_____________________________________________________________<br>Seattle Perl Users Group Mailing List<br>
POST TO: <a ymailto="mailto:spug-list@pm.org" href="mailto:spug-list@pm.org">spug-list@pm.org</a><br><span>SUBSCRIPTION: <a target="_blank" href="http://mail.pm.org/mailman/listinfo/spug-list">http://mail.pm.org/mailman/listinfo/spug-list</a></span><br> MEETINGS: 3rd Tuesdays<br><span> WEB PAGE: <a target="_blank" href="http://seattleperl.org/">http://seattleperl.org/</a></span><br></div></div>
</div><br>
</body></html>