1. Better Date Manipulation in PostgreSQL Queries

  2. Finding the Oldest/Youngest Records Within a Group

  3. Advanced Postgres Performance Tips

  4. Reading a Postgres EXPLAIN ANALYZE Query Plan

  5. ActiveRecord Eager Loading with Query Objects and Decorators

  6. Postgres Window Functions

  7. Why Postgres Won't Always Use an Index

  8. Back to Basics: Writing SQL Queries

  9. Refactoring Ruby Iteration Patterns to the Database

  10. Extract Mostly-Constant Data from the Database