Note that sqldf is primarily used for applying SQL against data frames and reading portions of large files into R.
If the problem is to fetch data from an existing relational database then see RODBC, RJDBC or else DBI and one of the database-specific dbi packages such as RSQLite, RMySQL, etc. On Fri, Nov 14, 2008 at 10:15 AM, Henrique Dallazuanna <[EMAIL PROTECTED]> wrote: > See sqldf package. > > On Fri, Nov 14, 2008 at 1:12 PM, Brigid Mooney <[EMAIL PROTECTED]> 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]] > > > ______________________________________________ > 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. > > ______________________________________________ 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.
