SQL - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
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
Postgres Window Functions

Take your queries to the next level with window functions.
Simon Taranto
September 16, 2014
- Web
- Performance
- PostgreSQL
- SQL
Why Postgres Won't Always Use an Index

Use SQL EXPLAIN to understand when and why indexes are used (or not).
Simon Taranto
July 25, 2014
- Web
- Performance
- PostgreSQL
- SQL
Back to Basics: Writing SQL Queries

An in-depth overview of INSERT, SELECT, UPDATE, and DELETE statements, ORDER BY, INNER JOIN, LEFT OUTER JOIN, WHERE, GROUP BY, and HAVING clauses, and topics such as join tables and sub-queries.
Britt Ballard
April 21, 2014
- Web
- Back To Basics
- SQL
Refactoring Ruby Iteration Patterns to the Database

Calculations across objects are ripe for using a map and an inject but frequently, with ActiveRecord, the solution is more elegant and faster if we can have SQL do the work instead.
Simon Taranto
April 15, 2014
- Web
- Rails
- SQL
Extract Mostly-Constant Data from the Database

How moving some data out of the database and into your codebase as well-named constants can decouple your code and improve performance.
Tute Costa
April 11, 2014
- Web
- Rails
- SQL
A Grand Piano for Your Violin

Thoughts on safe indexes to add to Rails app databases.
Matt Jankowski
August 15, 2009
- Web
- PostgreSQL
- SQL
depends

Sometimes in an app you need to do something in SQL and not in your app’s...
Jared Carroll
July 31, 2007
- Web
- Rails
- SQL
don't be normal

Database normalization, the database world’s equivalent of DRY, can lead you...
Jared Carroll
April 24, 2007
- Web
- Rails
- 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