[R] Embed SQL queries in R?

[Marc Schwartz]

on 11/14/2008 09:12 AM Brigid Mooney wrote:
> Hi All,
> 
> Most of the work I am doing with R uses data which I am pulling from various
> SQL queries.
> 
> To streamline the process even more, I was wondering if it was possible to
> embed SQL queries in R - that way avoiding the need to first get the data,
> then move to R to process it.
> 
> I haven't found anything out there on this yet, so if you know of a good
> resource that includes this topic, I would really appreciate it.
> 
> Thanks again for all your help!

You can secure data directly from most common relational data sources
within R. This is covered in the R Data Import/Export Manual:

  http://cran.r-project.org/doc/manuals/R-data.html

and is also available with your R installation.

There is also a R e-mail list specifically on database interfaces:

  https://stat.ethz.ch/mailman/listinfo/r-sig-db

HTH,

Marc Schwartz