Monthly Archives: January 2010

Horizontal Paging of Greenplum or Postgres Queries

Posted on January 26, 2010 by earl

When using gpsql or pgsql to query greenplum or postgres respectively, query results which exceed the width of your term will wrap in a very annoying fashion. To get horizontal paging, set the environmental variable PAGER: export PAGER=’less -RSFX’ then … Continue reading →

Posted in Data Munging | Tagged , | Leave a comment

Interactive Plotting in R

Posted on January 25, 2010 by earl

There are many ways to compare univariate distributions; one of my favorites is violin plots. However, if you are only comparing two distributions, then the best solution is often a scatter plot. To that end, I’ve build some code that … Continue reading →

Posted in Data Munging, Plotting, R, R Tip, Visualization | Leave a comment

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