New maintainer for DBI package
On Thu, Oct 17, 2013 at 11:28 PM, Sean O'Riordain <seanpor at acm.org> wrote:
A nice to have would be placeholders like in Perl DBI, refer http://www.perlmonks.org/?node_id=7548 So you can do things like # warning perl code! my $sth = $dbh->prepare_cached("insert into my_table (id, name) values (?, ?)"); $sth->execute('15', 'Foo'); # which in perl is cleaner, easier and generally faster than pasting things together into an sql statement.
Note that RSQLite has support for prepared queries. You can even do inserts or selects filling parameters from the rows of a data frame.
Seth Falcon | @sfalcon | http://userprimary.net/ [[alternative HTML version deleted]]