[R] db pkgs

[Prof Brian D Ripley]

On Thu, 1 Mar 2001, Natalie Hawkins wrote:

>
> Hi,
>
> I am wondering if anyone has had experience w/the R database
> packages: RMySQL, RODBC, RPgSQL, and/or RmSQL, and if so, if you have
> any recommendations to make.  We have some large tables we would like to
> store -- something like 5-10 columns by 3.5 mil rows (or maybe 7 mil
> rows).

Yes, some experience with all.  We need more to go on: your chosen OS, for
example.  Have you looked at my article in R-news 2001-1?  It even has some
recommendations ....

Looks like I would recommend MySQL + RODBC on Windows/Linux, perhaps
RMySQL elsewhere provided you only ever wanted to read from the tables.

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._