1. Understanding SQL GROUP BY

    Finally, you too can understand how to use GROUP BY in your SQL queries.

    Edward Loveall

  2. Understanding SQL JOIN

    A mental model to understand SQL’s JOIN.

    Edward Loveall

  3. Understanding SQL SELECT and WHERE

    See WHERE and SELECT visualized in this SQL primer.

    Edward Loveall

  4. Breaking Out of Ecto Schemas

    With Ecto, 🎶 you can always get what you want. And if you try sometimes, well, you might find, you can select want you need 🎶.

    German Velasco

  5. Sharing Query Logic Within ActiveRecord Models

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

    Chris Toomey

  6. Using doobie; Scala with PostgreSQL vs ActiveRecord

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

    Matt Sumner

  7. Back to basics: psql

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

    German Velasco

  8. Better Date Manipulation in PostgreSQL Queries

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

    Derrick Carr

  9. 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

  10. Advanced Postgres Performance Tips

    What do you do when indexes aren’t enough?

    Caleb Hearth

Sign up to receive a weekly recap from Giant Robots