Message-ID: <CANqbw6XMgTegMp+YqkEWsvz45OqcovZzX+Gue+tq4-6jH6pJHg@mail.gmail.com>
Date: 2013-10-18T23:10:23Z
From: Seth Falcon
Subject: New maintainer for DBI package
In-Reply-To: <CA+MmmT+1JwpPtsOnCx6=ub0HRx195vt2W+F7XNx0WbfZzZ-vFw@mail.gmail.com>
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]]