1. Finding the Oldest/Youngest Records Within a Group

  2. Advanced Postgres Performance Tips

  3. Reading a Postgres EXPLAIN ANALYZE Query Plan

  4. ActiveRecord Eager Loading with Query Objects and Decorators

  5. Postgres Window Functions

  6. Why Postgres Won't Always Use an Index

  7. Back to Basics: Writing SQL Queries

  8. Refactoring Ruby Iteration Patterns to the Database

  9. Extract Mostly-Constant Data from the Database

  10. A Grand Piano for Your Violin

Sign up to receive a weekly recap from thoughtbot