SQL - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
Understanding SQL JOIN

A mental model to understand SQL’s JOIN.
Edward Loveall
February 16, 2021
- SQL
Understanding SQL SELECT and WHERE

See WHERE and SELECT visualized in this SQL primer.
Edward Loveall
February 15, 2021
- SQL
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
February 24, 2020
- Ecto
- Elixir
- SQL
- Web
Using doobie; Scala with PostgreSQL vs ActiveRecord

I’ve wrapped up my second Scala client project, and I enjoyed SQL.
Matt Sumner
June 6, 2019
- Ruby
- Scala
- SQL
Back to basics: psql

The right tool for the right job, right? Well let me introduce you to psql.
German Velasco
March 14, 2019
Better Date Manipulation in PostgreSQL Queries

Use interval and date_trunc to make working with SQL dates easier.
Derrick Carr
September 19, 2017
- PostgreSQL
- SQL
- Data
- Web
Querying the oldest and newest records within an SQL group

How to find the oldest or most recent record associated with a particular foreign key.
Jack Wilson
September 18, 2017
- PostgreSQL
- SQL
- Databases
- Rails
Advanced Postgres Performance Tips

What do you do when indexes aren’t enough?
Caleb Hearth
July 29, 2016
- PostgreSQL
- Databases
- SQL
- Performance
Reading a Postgres EXPLAIN ANALYZE Query Plan

Take a guided tour through a query plan for a “simple” SQL query.
Caleb Hearth
July 26, 2016
- PostgreSQL
- Databases
- SQL
- Performance
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
September 19, 2014
- Web
- Rails
- SQL
- Performance
Sign up to receive a weekly recap from thoughtbot

Your email address

Looking for even more ways to stay connected?

Check out our feeds

Sign up to receive a weekly recap from thoughtbot