[R-sig-DB] [R] [R-pkgs] New package RPostgreSQL 0.1.0

[Prof Brian Ripley]

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 using gmail.com>
>   Dirk Eddelbuettel <edd using debian.org>
>
> -- 
> Three out of two people have difficulties with fractions.
>
> _______________________________________________
> R-packages mailing list
> R-packages using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-packages
>
> ______________________________________________
> R-help using 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 using 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