New package RPostgreSQL 0.1.0

On 17 October 2008 at 12:42, Prof Brian Ripley wrote:
| 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

Thank you very much!

I also learned from Jan that the simple (but too simple) configure.in that
avoids pg_config (which somehow wasn't in the path on Sameer's FC machine)
leads to malfunction on OS X, so I have to fix that too.

Do your FC / RH system all have pg_config in the path ?

| 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.

Right. I guess I need to document that. Exactly what file did you fetch?

| 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.

Because we cannot assume a Pg backend to be present and to be configured, we
cannot run tests automagically.

See inst/devTests in the sources, or
devTests/ in the installed package for some more tests -- not the most
refined set, but it grew as we grew the package.

| I'll put a Windows binary on CRAN extras, at least for now.

Many thanks for that, and thanks also for following up on r-sig-db!

Dirk


| 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