Rdbi
Rdbi is a general
database access framework for the R
statistical computing environment. It is the successor to
RPgSQL, a PostgreSQL specific
package. I have provided Rdbi binding for PostgreSQL. If you
would like to add bindings for your favorite database, please contact
me (see
Rdbi.PgSQL in
CVS for example code). If you already use RPgSQL, you will find
the Rdbi bindings 10-100 times faster on reads as all result fetch loops
have been moved into C code.
To download the R packages, visit CRAN
. Also, try typing "?update.packages" from the R prompt.
Example session:
conn <- dbConnect(PgSQL(), host = "myhost", dbname = "mydb")
res <- dbSendQuery(conn, "select * from mytable")
mydata <- dbGetResult(res)