DBIx::Simple opinion..

Qiang has asked for the wisdom of the Perl Monks concerning the following question:

hi,

does anyone has opinion or experience with DBIx::Simple in mod_perl env? it looks like a thin layer to DBI which i like.

i have found these two posts on perlmonks dated back to 2004 and 2005.

or everyone is using one of the ORM now..;-)

Comment on DBIx::Simple opinion..

Replies are listed 'Best First'.
Re: DBIx::Simple opinion.. by Juerd (Abbot) on Jun 13, 2007 at 22:00 UTC
does anyone has opinion or experience with DBIx::Simple in mod_perl env? I do :-).	[reply]
Re^2: DBIx::Simple opinion.. by Qiang (Friar) on Aug 28, 2007 at 16:11 UTC
i like to use `hashes` method in DBIx::Simple. however it is very inefficient and i am wondering why you don't use `bind_columns` as mentioned in DBI bind_columns personally i do it in the following way which eqivalent to fetchall_hashref. not sure how much efficient it is though. my (%row, @rows); $sth->bind_columns( \( @row{ @{$sth->{NAME_lc} } } )); while( $sth->fetch ) { push @rows, { %row }; }	[reply] [d/l] [select]
Re^3: DBIx::Simple opinion.. by Juerd (Abbot) on Sep 02, 2007 at 21:11 UTC
I haven't benchmarked it either. I recall having had reasons for not binding columns, but I don't remember the specifics. Juerd # { site => 'juerd.nl', do_not_use => 'spamtrap', perl6_server => 'feather' }	[reply]