[R] Re ading from a Database

[Whit Armstrong]

can  you show the list a more specific example of what you are trying to do?

most of the database packages support writeTable commands.  So, if you
can represent the data you are trying to write in a dataframe, then
you can probably send it to the database with R.

-Whit


On Wed, Mar 18, 2009 at 4:50 PM, DonkeyRhubarb <michaeligoe at gmail.com> wrote:
>
> Some of the simpler commands could surely be done using SQL-only queries, but
> thats too simple for my project. I need to create some more complex commands
> that would only be possible using R. Indeed if anyone has any suggestions
> for this, Id also appreciate that. Every little bit of information I get
> helps me finish college:-)
>
> Thanks for that info Ben and thanks to anyone else who shares some much
> needed insight with me.
>
> Ben Bolker wrote:
>>
>> DonkeyRhubarb <michaeligoe <at> gmail.com> writes:
>>
>>>
>>> I'm quite new to R and have limited experience. What Im trying to do is
>>> very
>>> important as it is part of my final year project; or more so the central
>>> idea behind it.
>>>
>>> I will be creating BibTex files to enter into a mySQL database. I then
>>> need
>>> to perform operations on this DB like 'return studies similar to x'.
>>>
>>> It's really just getting a start at this that I'm having trouble with and
>>> if
>>> anyone could offer any advice whatsoever I would be more than grateful.
>>>
>>> Many thanks.
>>>
>>
>>   Hmmm.  This sounds much more like a database question than
>> an R question.  R has various interfaces (RmySQL, RODBC, etc)
>> for interfaces to relational databases.  Section 4 of the
>> R data import/export manual gives quite a bit of detail.
>> I think that if you need more information on SQL queries etc.
>> you need to start with a local source (who is the advisor
>> for your project?)
>>
>>   good luck
>>     Ben Bolker
>>
>> ______________________________________________
>> 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.
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Reading-from-a-Database-tp22578072p22587990.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
>