[R] R and database access

[Adam Witney]

Hi,

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

adam

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._