[R-sig-DB] Is any database particularly better at "exchanging" large datasets with R?

[Paul Gilbert]

Sean Davis wrote:
> On Feb 6, 2008 2:10 PM, Thomas Pujol <thomas.pujol using yahoo.com> wrote:
> 
>>Is any database particularly better at "exchanging" data with R?
>>
>>Background:
>>Sometime during the next 12-months, I plan on configuring a new computer system on which I will primarily run "R" and a SQL database (Microsoft SQL Server, MySQL, Oracle, etc).  My primary goal is to "optimize" the system for R, and for passing data to and from R and the database.
>>
>>I work with large datasets, and therefore I "think" one of my most important goals should be to maximize the amount of RAM that R can utilize effectively.
>>
>>I am seeking advice concerning the database, version of R, OS,  processor, hard-drive/storage configuration, etc. that I should consider. (I am guessing that I should build a system with lots of RAM, and a Linux OS, but am seeking advice from the R community.) If I choose Linux, does it matter which version I use? Any opinion regarding  implementing a commercially supported version from a vendor such as Red Hat, Sun, etc? Is any database particularly better at "exchanging" data with R?
>>
>>While cost is of course a consideration, it is probably a secondary consideration to overall performance, reliability, and ease of ongoing maintenance/support.
> 
> 
> Hi, Thomas.
> 
> As for database, you'll probably need to be more specific about what
> you want to do.  Oracle, MySQL, and Postgresql (at least) have
> packages that support their use from R.  Other databases can be
> configured to use RODBC.  

Sean

I thought the only maintained and working interface to Postgres was 
RODBC.  Is there a package somewhere (other than the one for embedding R 
into Postgres)?  Is there a package that uses DBI?

Paul

 From the database point of view, Postgresql
> allows one to embed an R interpreter into the database.  As for
> hardware requirements, that will depend on your application, so again,
> you will probably need to be more specific.
> 
> Sean
> 
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
====================================================================================

La version française suit le texte anglais.

------------------------------------------------------------------------------------

This email may contain privileged and/or confidential information, and the Bank of
Canada does not waive any related rights. Any distribution, use, or copying of this
email or the information it contains by other than the intended recipient is
unauthorized. If you received this email in error please delete it immediately from
your system and notify the sender promptly by email that you have done so. 

------------------------------------------------------------------------------------

Le présent courriel peut contenir de l'information privilégiée ou confidentielle.
La Banque du Canada ne renonce pas aux droits qui s'y rapportent. Toute diffusion,
utilisation ou copie de ce courriel ou des renseignements qu'il contient par une
personne autre que le ou les destinataires désignés est interdite. Si vous recevez
ce courriel par erreur, veuillez le supprimer immédiatement et envoyer sans délai à
l'expéditeur un message électronique pour l'aviser que vous avez éliminé de votre
ordinateur toute copie du courriel reçu.