Tag Archives: R and Databases

Querying Postgres or Greenplum From R on a Mac, Installation Instructions

Posted on January 21, 2010 by earl

NB: this works on 64b versions of R; I tested it with the R64 app with R version 2.10.1 on Snow Leopard Step by step instructions for talking to Postgres or Greenplum: install macports install postgres; I used 8.4 sudo … Continue reading →

Posted in Data Munging, R, R Tip | Tagged , , | Leave a comment

Querying Databases From R on a Mac

Posted on January 11, 2010 by earl

I use a mac, currently running OS 10.6 / Snow Leopard, and I’d like to query our greenplum / postgres database from R. This used to work with R 2.9, but I unfortunately had to upgrade R, and R 2.10 … Continue reading →

Posted in Data Munging, R, R Tip | Tagged , , , | Leave a comment

Querying Postgres or Greenplum from R on a Mac

Posted on December 31, 2009 by earl

So, I’m using snow leopard, and I want to query our postgres / greenplum database. First things first: I’m familiar with the RODBC package on CRAN. This installs fine, since it’s a binary package. I also installed the ODBC Administrator … Continue reading →

Posted in Data Munging, R, R Tip | Tagged , , , | Leave a comment

Querying Databases in R, on Mac OS

Posted on September 7, 2009 by earl

Unfortunately, it appears with the recent release of 10.6 / Snow Leopard Apple has removed the ODBC Administrator Tool from the OS. It can still be downloaded from Apple.

Posted in Uncategorized | Tagged , , , | Leave a comment

Querying Databases in R

Posted on August 14, 2009 by earl

One of the first things you’ll want to do in R is set it up to talk to databases. The easiest way to do this is using ODBC, via package RODBC. To get the package, run > install.packages(RODBC) Once you … Continue reading →

Posted in Data Munging, R, R Tip | Tagged , , , , , | Leave a comment