[R] R and PostgreSQL

[Timothy H. Keitt]

A  slightly updated version can be found at http://rpgsql.sourceforge.com/  I think the
main reason its in devel is I still need to tweek the configure/install scripts.

T.

Peter Dalgaard BSA wrote:

> Paul Condon <pecondon at quiknet.com> writes:
>
> > I am a user of PostgreSQL. I'm interested in generating cross-tabulations of RDBMS
> > data. Cross-tabulations are not really possible within the RDBMS paradigm, but
> > they are part of the base tutorial stuff of R. I can move the data to R using a
> > copy command in Postgres and a the read.table() function in R. But is there a
> > better way? Can a system be set up using CORBA or ODBC that lets one access (and
> > preprocess) the data from within R? What are the limitations on data set size
> > within R?
>
> There's a contributed package called RPgSQL sitting in
>
> http://cran.r-project.org/src/contrib/Devel/RPgSQL_0.5-1.tar.gz
>
> I've forgotten the reason why it is in the Devel section, but it does
> some of the things you need.
>
> R is usually limited by the fact that it keeps entire datasets in
> memory (see also ?Memory), but the RPgSQL package works around this so
> that you need only store selected columns.
>
> --
>    O__  ---- Peter Dalgaard             Blegdamsvej 3
>   c/ /'_ --- Dept. of Biostatistics     2200 Cph. N
>  (*) \(*) -- University of Copenhagen   Denmark      Ph: (+45) 35327918
> ~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)             FAX: (+45) 35327907
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> 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
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

--
Timothy H. Keitt
National Center for Ecological Analysis and Synthesis
735 State Street, Suite 300, Santa Barbara, CA 93101
Phone: 805-892-2519, FAX: 805-892-2510
http://www.nceas.ucsb.edu/~keitt/



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