[R] Embed SQL queries in R?

[Gabor Grothendieck]

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 <wwwhsd at gmail.com> wrote:
> See sqldf package.
>
> On Fri, Nov 14, 2008 at 1:12 PM, Brigid Mooney <bkmooney at 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 at 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 at 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.
>
>