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! [[alternative HTML version deleted]]
See sqldf package. On Fri, Nov 14, 2008 at 1:12 PM, Brigid Mooney <bkmooney@gmail.com> 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! > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40" S 49° 16' 22" O [[alternative HTML version deleted]]
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