[R] R and PostgreSQL
Timothy H. Keitt
keitt at nceas.ucsb.edu
Mon Jun 19 03:28:24 CEST 2000
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.
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
> 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
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