SQL - Giant Robots Smashing Into Other Giant Robots

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