1. Understanding SQL GROUP BY

  2. Understanding SQL JOIN

  3. Understanding SQL SELECT and WHERE

  4. Breaking Out of Ecto Schemas

  5. Sharing Query Logic Within ActiveRecord Models

  6. Using doobie; Scala with PostgreSQL vs ActiveRecord

  7. Back to basics: psql

  8. Better Date Manipulation in PostgreSQL Queries

  9. Finding the Oldest/Youngest Records Within a Group

  10. Advanced Postgres Performance Tips

Sign up to receive a weekly recap from Giant Robots