1. Choosing the right database index type

  2. Understanding SQL GROUP BY

  3. Understanding SQL JOIN

  4. Understanding SQL SELECT and WHERE

  5. Breaking Out of Ecto Schemas

  6. Sharing Query Logic Within ActiveRecord Models

  7. Using doobie; Scala with PostgreSQL vs ActiveRecord

  8. Back to basics: psql

  9. Better Date Manipulation in PostgreSQL Queries

  10. Finding the Oldest/Youngest Records Within a Group

Sign up to receive a weekly recap from Giant Robots