Databases - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
Enum validations and database constraints in Rails 7.1

How to add model validation for a column using a PostgreSQL enum type in Rails 7.1.
Sally Hall
April 16, 2024
- Web
- Rails
- Active Record
- Databases
- Validation
- Enum
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
This Week in #dev (Feb 9, 2024)

Speed up your tests, a nice SQL trick, and a Jest global that you might not know about.
thoughtbot
February 19, 2024
- This Week In Dev
- Databases
- Rails
- Testing
- Jest
- Performance
This Week in #dev (Jan 26, 2024)

Inserting 100,000,000 rows into the database, how Turbo can break OAuth forms, and more!
thoughtbot
February 5, 2024
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
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
This week in #dev (Mar 24, 2023)

It’s all about databases in this edition!
thoughtbot
April 7, 2023
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
Testing Techniques: The I/O Table

Leverage the power of the I/O table mindset to make your tests as maintainable and readable as possible.
Thiago Araújo Silva
April 21, 2022
- Testing
- Ruby
- Databases
- PostgreSQL
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