New package RPostgreSQL 0.1.0
Following up the Windows point on a specialized list (R-sig-db), I was able to get this to build with setenv PG_HOME D:/Program Files/PostgreSQL/8.3 and a src/Makevars.win containing PKG_CPPFLAGS=-I"$(PG_HOME)"/include PKG_LIBS=-L"$(PG_HOME)"/lib -lpq The problem is that you do need a fairly complete Windows install of PostgreSQL, and I had to go back and add the development files. Then you will need libpq.dll in your path: that is in (PG_HOME/bin). The tests/*.R did not work, but that's a permissions issue (as for me on Linux) and I needed to specify user="postgresql" and password="...". Then minimal tests worked suitably. I'll put a Windows binary on CRAN extras, at least for now.
On Tue, 14 Oct 2008, Dirk Eddelbuettel wrote:
RPostgreSQL version 0.1.0
We are pround to announce the availability of the RPostgreSQL package on CRAN
and its mirrors. This package provides an a DBI-compliant interface between
PostgreSQL and R.
RPostgreSQL was developed as part of the Google Summer of Code 2008 program
by Sameer Kumar Prayaga.
Some highlights:
o Implemented all the DBI features
o Added support for transaction management
o Added type mapping for dates & timestamps
Known bugs/deficiencies:
o Building on Windows unknown/untested. Feedback welcome
RPostgreSQL is hosted on Google Code, for more information see
http://rpostgresql.googlecode.com/
For any suggestions and queries, please contact:
Sameer Kumar Prayaga <sameer.bits at gmail.com>
Dirk Eddelbuettel <edd at debian.org>
--
Three out of two people have difficulties with fractions.
_______________________________________________ R-packages mailing list R-packages at r-project.org https://stat.ethz.ch/mailman/listinfo/r-packages ______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595