SQL - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
Testing SQL queries in a Ruby service

An epic journey of facing MSSQL and missing Rails.
Sally Hall
December 16, 2024
- SQL
- Testing
- Stories
- Ruby
- Web
Testing SQL Performance in PostgreSQL

Measure query speed with Postgres’ EXPLAIN ANALYZE.
Elisa Verna
December 15, 2023
Joining Postgres tables using arrays of IDs

Some tips on how to do many-to-many SQL queries without a normal join table.
Dave Iverson
December 5, 2023
- Databases
- PostgreSQL
- SQL
- Prisma
- Airtable
3 ways to model an associated collection in Rails

A look at the Postgres array type and good old join tables, each with their advantages and disadvantages.
Dimiter Petrov
November 23, 2023
- Rails
- Databases
- SQL
- PostgreSQL
Sharing Query Logic Within ActiveRecord Models

Re-use collection query logic within model instances to avoid duplication and get the best performance.
Chris Toomey
November 22, 2023
- Rails
- SQL
- Web
Detect anomalies in user behavior using Rails and PostgreSQL

You probably use some type of error monitoring software to notify you when an exception is raised in your application, but are you being notified when there is an anomaly in user behavior?
Steve Polito
September 29, 2022
- PostgreSQL
- SQL
- Analytics
- Rails
Query by Duration in Active Record

How do you even save a “duration”, let alone query for records by that value? It’s actually easier than you think.
Steve Polito
June 7, 2022
- Rails
- Databases
- PostgreSQL
- Active Record
- SQL
Choosing the right database index type

A quick introduction to which database index types are right for the task at hand in Postgresql.
Greg Fisher
December 16, 2021
- PostgreSQL
- SQL
- Databases
- Performance
Understanding SQL GROUP BY

Finally, you too can understand how to use GROUP BY in your SQL queries.
Edward Loveall
February 17, 2021
- SQL
Understanding SQL JOIN

A mental model to understand SQL’s JOIN.
Edward Loveall
February 16, 2021
- SQL
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