Apr 23, 2015
Materialized View Strategies Using PostgreSQL —
Queries returning aggregate, summary, and computed data are frequently used in application development. Sometimes these queries are not fast enough. Caching query results using Memcached or Redis is a common approach for resolving these performance issues. However, these bring their own challenges. Before reaching for an external tool it is worth examining what techniques PostgreSQL offers for caching query results.…
Dec 18, 2014
16 Tips from the 2014 Winter Miniconf —
Hashrocket hosts an internal conference twice a year called Miniconf where we take a day to share ideas with each other. This last Miniconf I gave a quick 20 minute talk with a grab bag of Linux, shell, PostgreSQL, and Ruby tricks. This article is that talk converted to text format.…
Oct 4, 2014
React2FS - React to File System Changes —
React to file system changes by executing a command…
Aug 7, 2014
Go Performance Observations —
In the course of optimizing the pgx PostgreSQL driver I observed a number of performance characteristics of Go that I hope you will find useful.…
Apr 19, 2014
Tern 1.0.0 Released —
New release of Tern rewritten in Go…
Aug 18, 2013
Writable Common Table Expressions —
Writable common table expressions are a powerful feature of PostgreSQL that is rarely used when building applications with an ORM like ActiveRecord. It allows inserts, updates, and deletes to be performed in the WITH clause of an SQL statement. Here are a few techniques that I have found useful.…
Feb 22, 2013
Surus 0.4.0 Released —
Surus now can use PostgreSQL’s JSON functions to build JSON much faster than Rails to_json…
Jan 29, 2013
Faster JSON Generation with PostgreSQL —
A new feature in PostgreSQL 9.2 is JSON support. It includes a JSON data type and two JSON functions. These allow us to return JSON directly from the database server. This article covers how it is done and includes a benchmark comparing it with traditional Rails JSON generation techniques.…
Aug 25, 2012
Text Tunnel - Remote Text Editing —
Use your favorite GUI text editor on remote servers over SSH.…
Feb 16, 2012
Surus - PostgreSQL Acceleration for ActiveRecord —
Accelerate ActiveRecord with PostgreSQL specific support…