Shahaf Abileah

Since Dec 2011 we’ve been storing a small portion of our data as JSON in Postgres.  This blog post gives a quick overview of why we decided to do this, how it works, and what we’ve learned so far. Why JSON in Postgres? Redfin’s basic stack includes a Java-based web app on top of a

A few months ago I attended the PostgreSQL conference in Portland, OR. There were a lot of talks ranging from hard-core stuff like Neil Conway‘s talk about the internals of query execution, to random fun stuff like David Fetter‘s discussion of procedural languages, including LOLCODE. During their talks, a few people mentioned a handy function

A couple of weeks ago we released an upgrade to the Redfin site. Some of the changes were obvious: we now support Safari, we show polygons for different region types on the map (cities, neighborhoods, zip codes, etc.), we show price history on the listing details page, we allow users to download search results as