[R] R and PostgreSQL
Timothy H. Keitt
keitt at nceas.ucsb.edu
Mon Jun 19 17:53:33 CEST 2000
Oops... make that http://rpgsql.sourceforge.net/
"Timothy H. Keitt" wrote:
> 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
> > 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
> 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