1. Query by Duration in Active Record

  2. Choosing the right database index type

  3. Understanding SQL GROUP BY

  4. Understanding SQL JOIN

  5. Understanding SQL SELECT and WHERE

  6. Breaking Out of Ecto Schemas

  7. Sharing Query Logic Within ActiveRecord Models

  8. Using doobie; Scala with PostgreSQL vs ActiveRecord

  9. Back to basics: psql

  10. Better Date Manipulation in PostgreSQL Queries

Sign up to receive a weekly recap from thoughtbot