Hashrocket.com / blog

Recent Articles

Small bg article jackc 20160210

Custom Aggregates in PostgreSQL

Posted by

Given a bank account of debit and credit transactions, what is the greatest balance the account ever had? Given a hotel with arrivals and departures, what is the greatest number of guests the hotel ever had? Both of these are examples of finding the greatest running total. Finding the greatest running total is a great exercise with which to explore some of the lesser known features of PostgreSQL such as window functions, custom aggregates, and...

Small 14303493780 00723c78d8 o

Stop Tinkering and Prioritize!

Posted by

So you're in full-scale development on your app. Congratulations! Now you have a new problem: A huge pile of upcoming features, bugs and user requests. Wise prioritization is crucial to ensure you achieve your goals.