[R-sig-DB] New maintainer for DBI package

[Sean O'Riordain]

Hi Hadley,
Great to hear.

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.

Though I'm not doing any database work at the moment so I'm in no
particular rush - but they're so nice and easy to use :-)

Kind regards,
Sean

On 18 October 2013 04:08, Hadley Wickham <h.wickham using gmail.com> wrote:
> Hi all,
>
> This is just a quick note to let you know that I've taken over the
> maintainership of the DBI package, and it has a new home at
> https://github.com/rstats-db/dbi
>
> I'll be using the mailing list as a venue to discuss some changes I'd
> like to make to DBI. The goal is to make the minimal set of changes in
> order to:
>
> * add new generics currently defined by individual packages (e.g.
> dbApply, dbBeginTransaction, dbSendPreparedQuery)
>
> * rationalise escaping, moving from the current blacklist based
> system, to one where every identifier is escaped automatically using
> the rules of the host database
>
> * start developing a common test suite that can be applied to any
> package the implements the DBI package.
>
> I'll start some discussions on these topics next week, but please also
> feel free to comment on any of the smaller issues listed at
> https://github.com/rstats-db/DBI/issues
>
> Hadley
>
> --
> Chief Scientist, RStudio
> http://had.co.nz/
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db