Acme-CPANModules-Import-CPANRatings-User-davidgaramond
view release on metacpan or search on metacpan
devdata/davidgaramond view on Meta::CPAN
I agree with the previous reviewer. IMO, overall this module is not necessary. Plain DBI is actually simple enough for simple cases. Maybe the author of Mysqlsimple did not realize this. Let's compare:
<br><br>* Retrieving a single row:
<br>
Mysqlsimple: my ($v1,$v2) = $db->get_row("select v1,v2 from table");
<br>
DBI: my ($v1, $v2) = $dbh->selectrow_array("select v1,v2 from table");
<br><br>* Retrieving a single row (with params):
<br>
Mysqlsimple: my ($v1,$v2) = $db->get_row("select v1,v2 from table where cond1=? and cond2=?", [$cond1,$cond2]);
<br>
DBI: my ($v1,$v2) = $db->selectrow_array("select v1,v2 from table where cond1=? and cond2=?", {}, $cond1,$cond2);
<br><br>* Retrieving all rows with params:
<br>
Mysqlsimple: my $rows = $db->get_rows(..., [$param1, $param2]);
<br>
DBI: my $rows = $dbh->selectall_arrayref(..., {}, $param1, $param2);
<br><br>* do() with params:
<br>
Mysqlsimple: my $rows = $db->do(..., [$param1, $param2]);
<br>
DBI: my $rows = $dbh->do(..., {}, $param1, $param2);
<br><br>As you can see, the differences are minimal.
<br>
</blockquote>
<div class="review_footer">
<p class="review_attribution">
<a href="/user/davidgaramond">David Garamond</a> - 2008-05-03T20:46:28
(<a href="/dist/DBI-Mysqlsimple#4106">permalink</a>)
</p>
<div class="helpfulq">
4 out of 4 found this review helpful.
Was this review helpful to you?
<!-- we should add non-js links to rate stuff helpful/not helpful too... -->
<span class="helpful helpful_yes">Yes</span>
<span class="helpful helpful_no" >No</span>
<span class="thanks"></span>
</div><!-- helpfulq -->
</div><!-- review_footer -->
</div>
<div class="review" data-review="3794" data-user="8653">
<a name="3794"></a>
<h3 class="review_header">
<a href="/dist/Carp-Always">
Carp-Always</a>
(<a href="https://metacpan.org/release/Carp-Always/">0.09</a>)
<img src="//cdn.perl.org/perlweb/cpanratings/images/stars-5.0.png" alt="*****">
</h3>
<blockquote class="review_text">
Modules like this deserve to be more well-known and should perhaps included in core Perl (or even become a command-line switch). I'm never comfortable with Carp and all the "complexity" of using it. What I wanted is simple, when debugging I...
</blockquote>
<div class="review_footer">
<p class="review_attribution">
<a href="/user/davidgaramond">David Garamond</a> - 2008-02-15T18:41:17
(<a href="/dist/Carp-Always#3794">permalink</a>)
</p>
<div class="helpfulq">
8 out of 8 found this review helpful.
Was this review helpful to you?
<!-- we should add non-js links to rate stuff helpful/not helpful too... -->
<span class="helpful helpful_yes">Yes</span>
<span class="helpful helpful_no" >No</span>
<span class="thanks"></span>
</div><!-- helpfulq -->
</div><!-- review_footer -->
</div>
<div class="review" data-review="3548" data-user="8653">
<a name="3548"></a>
<h3 class="review_header">
<a href="/dist/Data-Dump">
Data-Dump</a>
(<a href="https://metacpan.org/release/Data-Dump/">1.08</a>)
<img src="//cdn.perl.org/perlweb/cpanratings/images/stars-5.0.png" alt="*****">
</h3>
<blockquote class="review_text">
I've envied Ruby users which can use just "p" to print out data structures instead of us which used to have to do 'use Data::Dumper; print Dumper(...);'. And even then there's this '$VAR1 = ' garbage which 99% of the time is not wanted. Whi...
</blockquote>
<div class="review_footer">
<p class="review_attribution">
<a href="/user/davidgaramond">David Garamond</a> - 2007-12-06T03:02:17
(<a href="/dist/Data-Dump#3548">permalink</a>)
</p>
( run in 0.474 second using v1.01-cache-2.11-cpan-39bf76dae61 )