PostgreSQL - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
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
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
Database View Backed Scopes In Rails

How do you manage queries when your Rails application isn’t the only thing reading your database?
Steve Polito
November 20, 2023
- Rails
- Web
- PostgreSQL
This Week in #dev (Jun 16, 2023)

Highlights of what happened in our #dev channel on Slack this week.
thoughtbot
June 23, 2023
- This Week In Dev
- TIL
- PostgreSQL
- Databases
- Rails
Are you absolutely sure your `has_one` association really has one association?

Learn about an unexpected limitation with this API and how to combat it universally.
Steve Polito
June 5, 2023
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