Bruce Momjian has just published a book on PostgreSQL that should be
available from bookstores in the next month or so. It can be
downloaded as a PDF file now from
http://www.postgresql.org/docs/awbook.html
I found the book to be well written and informative. I recommend it.
Especially if you have to deal with large data sets, the combination
of relational databases and R is very useful. Currently I am working
on a project where we have information on 3.5 million subjects
amounting to a total of 10.5 million records. Processing these in
MySQL and PostgreSQL is much, much more efficient than what my
colleagues were doing with SAS and SPSS. We took a sample of 180,000
subjects (550,000 records) and fit multilevel (linear mixed-effects)
models using lme in R after accessing the data from the relational
database.
--
Douglas Bates bates@stat.wisc.edu
Statistics Department 608/262-2598
University of Wisconsin - Madison http://www.stat.wisc.edu/~bates/
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-devel 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-devel-request@stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._