<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.1" -->
<rss version="0.92">
<channel>
	<title>Stochastic Nonsense</title>
	<link>http://blog.earlh.com</link>
	<description></description>
	<lastBuildDate>Sat, 10 Jul 2010 23:17:27 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Horizontal Paging of Greenplum or Postgres Queries</title>
		<description><![CDATA[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 either in your psql or gpsql session, or in your .psqlrc file,


\pset pager always


Note that if [...]]]></description>
		<link>http://blog.earlh.com/index.php/2010/01/horizontal-paging-of-greenplum-or-postgres-queries/</link>
			</item>
	<item>
		<title>Interactive Plotting in R</title>
		<description><![CDATA[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&#8217;ve build some code that creates an interactive scatter plot of two distributions and allows you to interactively [...]]]></description>
		<link>http://blog.earlh.com/index.php/2010/01/interactive-plotting-in-r/</link>
			</item>
	<item>
		<title>Querying Postgres or Greenplum From R on a Mac, Installation Instructions</title>
		<description><![CDATA[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 port install postgresql84



 in a shell, create an environmental variable PG_CONFIG pointing to the pg_config binary installed [...]]]></description>
		<link>http://blog.earlh.com/index.php/2010/01/querying-postgres-or-greenplum-from-r-on-a-mac-installation-instructions/</link>
			</item>
	<item>
		<title>Querying Databases From R on a Mac</title>
		<description><![CDATA[I use a mac, currently running OS 10.6 / Snow Leopard, and I&#8217;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 on the mac is a 64 bit app.  So, I want to use [...]]]></description>
		<link>http://blog.earlh.com/index.php/2010/01/querying-databases-from-r-on-a-mac/</link>
			</item>
	<item>
		<title>Querying Postgres or Greenplum from R on a Mac</title>
		<description><![CDATA[So, I&#8217;m using snow leopard, and I want to query our postgres / greenplum database.
First things first: I&#8217;m familiar with the RODBC package on CRAN.  This installs fine, since it&#8217;s a binary package.  I also installed the ODBC Administrator app that you have to download from apple  here .  Now all [...]]]></description>
		<link>http://blog.earlh.com/index.php/2009/12/querying-postgres-or-greenplum-from-r-on-a-mac/</link>
			</item>
	<item>
		<title>Plotting in Grids</title>
		<description><![CDATA[
	This is post #12 in a running  series  about plotting in R.

I regularly find myself wanting to show arrays or grids of plots in R.  This is straightforward using par and mfrow as long as you want a symmetric, evenly spaced grid of plots.  Unfortunately, this often is not what I [...]]]></description>
		<link>http://blog.earlh.com/index.php/2009/12/plotting-in-grid/</link>
			</item>
	<item>
		<title>Querying Databases in R, on Mac OS</title>
		<description><![CDATA[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.
]]></description>
		<link>http://blog.earlh.com/index.php/2009/09/querying-databases-in-r-on-mac-os/</link>
			</item>
	<item>
		<title>Querying Databases in R</title>
		<description><![CDATA[One of the first things you&#8217;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 have RODBC installed, you call it in R as follows.  But it&#8217;s very simple: a bit [...]]]></description>
		<link>http://blog.earlh.com/index.php/2009/08/querying-databases-in-r/</link>
			</item>
	<item>
		<title>MySQL, Batch Imports, and Rails</title>
		<description><![CDATA[I really love Rails, but it&#8217;s not the most performant code in the world.  Though it doesn&#8217;t often arise in CRUD programming, if you do any sort of stats, ML, or data analytics, you&#8217;ll frequently find yourself wanting to import lots of data into your db.  You could create an ActiveRecord object for [...]]]></description>
		<link>http://blog.earlh.com/index.php/2009/08/mysql-batch-imports-and-rails/</link>
			</item>
	<item>
		<title>R Dates &#8211; Recovering and Converting From Integers</title>
		<description><![CDATA[One problem with R is that dates (class Date) are internally stored as integer numbers of days elapsed since 1 January 1970 and R sometimes loses the dateness of the variables and thinks of it only as an integer.  So in the first line, we take the range of dates present in our data, [...]]]></description>
		<link>http://blog.earlh.com/index.php/2009/08/r-dates-recovering-and-converting-from-integers/</link>
			</item>
</channel>
</rss>
