[R] R and database access

Adam Witney awitney at sghms.ac.uk
Fri Sep 13 11:38:33 CEST 2002


I am relatively new at R, but I would like to be able to directly access my
MySQL and PostgreSQL databases from R. I have been looking around CRAN and
searching through Google, however I am not sure what are the best options. I
have seen

DBI         - not sure how this works
Rdbi        - not sure how this works
Rdbi.PgSQL  - can install, but fails on trying to load
RODBC       - cannot connect (I cannot find any troubleshooting guides)
RPgSQL      - can install, but fails on trying to load
RMySQL      - installation fails

(System = Mac OSX 10.2)

Which is considered the most up to date way of achieving this connection?

Thanks for any help


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

More information about the R-help mailing list