Postgresql Options for Mac OS X
Thanks, I am looking into RODBC. So which approach is considered the most used?
On May 12, 2009, at 12:09 AM, Prof Brian Ripley wrote:
On Mon, 11 May 2009, Neil Tiffin wrote:
In trying to figure out how the best way to access a postgresql database from R on Mac OS X. Currently my database has 88 million rows (9 GB) and is growing so I am looking for a stable interface. The following options seem to be available: 1. RdbiPgSQL_1.18.1 2. RPostgreSQL_0.1-4 3. TSPostgreSQL_2009.3-2
You have omitted RODBC, since PostgreSQL has a mature ODBC driver. 3) Is a special-purpose layer over 2).
These packages seemed to be obsolete and no longer supported/ recommended: 4. RPgSQL 1.0 5. Rdbi 0.1.2 Results ====== #1 relies on #5 and has an older connection syntax. #2 appears relatively new and has not reached 1.0 status yet. For someone used to libpq the interface is very familiar. #3 relies on #2 and not sure what it adds as the docs did not install correctly, nor are they accessible from CRAN. All 3 packages compiled and installed on Mac OS X even though #2 and #3 reported failures in CRAN.
Have you looked at the failures? RPostgreSQL failed to install because the build machine does not have PostgreSQL installed.
Have not tried to actually use them yet. Conclusion ========= Use #2 even though it does not seem very mature. Questions ======== Is this a good summary of the state of accessing postgresql from R or have I missed something?
The second.
Is RPostgreSQL being used anyplace and is it stable? Neil Chicago