1. Sharing Query Logic Within ActiveRecord Models

    Re-use collection query logic within model instances to avoid duplication and get the best performance.

    Chris Toomey

  2. Using doobie; Scala with PostgreSQL vs ActiveRecord

    I’ve wrapped up my second Scala client project, and I enjoyed SQL.

    Matt Sumner

  3. Back to basics: psql

    The right tool for the right job, right? Well let me introduce you to psql.

    German Velasco

  4. Better Date Manipulation in PostgreSQL Queries

    Use interval and date_trunc to make working with SQL dates easier.

    Derrick Carr

  5. Finding the Oldest/Youngest Records Within a Group

    How to find the oldest or most recent record associated with a particular foreign key.

    Jack Wilson

  6. Advanced Postgres Performance Tips

    What do you do when indexes aren’t enough?

    Caleb Thompson

  7. Reading a Postgres EXPLAIN ANALYZE Query Plan

    Take a guided tour through a query plan for a “simple” SQL query.

    Caleb Thompson

  8. ActiveRecord Eager Loading with Query Objects and Decorators

    How can you plug complex, multi-model SQL queries into ActiveRecord models so that you can use them in your views?

    Joe Ferris

  9. Postgres Window Functions

    Take your queries to the next level with window functions.

    Simon Taranto

  10. Why Postgres Won't Always Use an Index

    Use SQL EXPLAIN to understand when and why indexes are used (or not).

    Simon Taranto

Sign up to receive a weekly recap from Giant Robots