PostgreSQL - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
Inserting State Transitions in Postgres

An append-only status model gives you full history, but concurrent transitions can produce contradictory records. Here’s how to prevent that.
Thiago Araújo Silva
August 24, 2026
- Databases
- PostgreSQL
- SQL
Modeling State Transitions in Postgres

Status starts as a column. Then someone asks “who was denied last Tuesday?” and the schema can’t answer. Model each status change as its own row from the start, without sacrificing read performance.
Thiago Araújo Silva
August 11, 2026
- Databases
- PostgreSQL
- SQL
Announcing Michel: A scheduling gem for health tech

Remove bottlenecks to booking appointments by enabling self-scheduling within your app.
Sally Hall
February 5, 2026
- Health Tech
- Databases
- Ruby On Rails
- PostgreSQL
- Open
- Open Source
- Performance
- Web
Do you really know how to ORDER BY?

The perils of a seemingly harmless ORDER BY clause.
Thiago Araújo Silva
June 2, 2025
- Rails
- SQL
- PostgreSQL
This week in #dev (Aug 23, 2024)

Using constraints in Postgres and querying LLMs in the terminal.
thoughtbot
September 2, 2024
Monitoring PostgreSQL on AWS RDS for slow queries

Some helpful tips to fixing slow database queries before they become a problem.
Olamide Olaoye
February 29, 2024
- AWS
- PostgreSQL
- Databases
- Debugging
- DevOps
Handling external API errors: A transactional approach

Clarifying a few possible ways to implement transactional workflows when working with external APIs.
Thiago Araújo Silva
January 23, 2024
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
Are your polymorphic relationships correctly enforced?

Learn how to strike a balance between flexibility and data integrity with a partial index and validations.
Steve Polito
December 1, 2023
- Web
- Rails
- PostgreSQL
- Active Record
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