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

[Bo Zhao]

it is a exciting news that the RPostgreSQL 1.0 released.

On Fri, Oct 17, 2008 at 8:44 AM, Prof Brian Ripley
<ripley using stats.ox.ac.uk> wrote:
> On Fri, 17 Oct 2008, Dirk Eddelbuettel wrote:
>
>> 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 ?
>
> Those which have development files on.  (We have some production PostgreSQL
> systems without it, since the CMS for our websites runs on PostgreSQL.)
>
> gannet% whereis pg_config
> pg_config: /usr/bin/pg_config /usr/include/pg_config.h
> /usr/share/man/man1/pg_config.1.gz
> gannet% rpm -q --whatprovides /usr/bin/pg_config
> postgresql-devel-8.2.10-1.fc8
>
> so it is part of the -devel RPM as one might expect from RH.
>
>> | 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?
>
> It's part of the standard .msi installer, but you have to select non-default
> options, the Development group (only to do a source build of RPostgreSQL, as
> far as I can tell).  It *should* be easy to go back and add those options,
> but on my box the installation path had been lost so I actually had to
> uninstall and reinstall.
>
>> | 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.
>
> Sure, but even if it is, a standard setup (even on Windows) will require
> both a user and a password (and the only user you can guarantee is present
> is "postgresql").  I was just warning people that failure is expected.
>
>> 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 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
>>
>> --
>> Three out of two people have difficulties with fractions.
>>
>
> --
> 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
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>



-- 
Bo, Zhao
Dept. of Urban & Regional Planning
University of Florida.
Mobile: +1-352-235-5029
Email: bo using ufl.edu
Site: http://www.geoinformatics.cn
Coordinates: 29°37'42"N  82°22'27"W

This information is protected by FERPA and cannot be re-disclosed