Absolutely easy yet fast and powerful SQL access.
This module wraps the DBI prepare/bind/execute calls into a single "sql_exec" call, complete with statement caching, so you get the efficiency of prepare, the safety of using placeholders and the speed of bound result values in a simple call. Example:
my $st = sql_exec \my ($id, $name),
"select id, name from db where name like %",
"pfx%";
while ($st->fetch) {
print "$id $name\n";
}
| CPAN | File Releases (CPAN) |
| CVS | Browsable CVS module 'PApp-SQL' |
| CVS | Anonymous CVS: cvs -z3 -d :pserver:anonymous@cvs.schmorp.de/schmorpforge co PApp-SQL |
| METACPAN | MetaCPAN page |
| IRC | Server irc.schmorp.de, channel #schmorpforge, user schmorp (say hi and wait a few minutes or hours, or /msg schmorp directly)) |
| POD | Main Manual Page |