Skip to main content
thoughtbot thoughtbot
  • Live on Twitch!

    thoughtbot is livestreaming

    Work alongside the thoughtbot team as we collaborate with each other and our clients, live. Ask us anything, we're live right now!

  • Case Studies
  • Blog
  • Let’s Talk
Live on Twitch!

thoughtbot is livestreaming

Work alongside the thoughtbot team as we collaborate with each other and our clients, live. Ask us anything, we're live right now!

Let’s get started!
View all Services
Web Development
  • Ruby on Rails
  • Hotwire
  • AI and Machine Learning
  • React
  • Maintenance
Mobile Development
  • React Native
  • iOS
  • Android
Design
  • UX, UI, and Product Design
  • Design Research
  • Design Systems
Product
  • Product Management
  • Product Design Sprint
  • Research and Strategic Insights
  • Accessibility
Team and Processes
  • Team Augmentation
  • Fractional Leadership
  • Level up your junior team
View all Services
View all Resources
Development
  • Tech Leadership Resources
  • Open Source
  • Books
  • The Bike Shed Podcast
  • Live Streaming on YouTube
The business of great software
  • Playbook
  • Startup Incubator
  • Giant Robots Smashing Into Other Giant Robots Podcast
  • Design Sprint Guide
  • Live Streaming on LinkedIn
View all Resources

Database Articles

Written by thoughtbot, your expert strategy, design, product management, and development partner.

    • All Topics
    • Design
    • Web
    • iOS
    • Android
    • More topics
  1. 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
    • Database
    • Validation
    • Enum
  2. 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
    • Database
    • Debugging
    • DevOps
  3. 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
    • Database
    • Databases
    • Postgres
    • PostgreSQL
    • SQL
    • Prisma
    • Airtable
  4. 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
    • Database
    • Postgres
  5. Recurring Events and PostgreSQL

    Scheduling, recurring events and relative dates have always been hard. Until now.

    Jonas Meinerz
    March 24, 2020
    • Postgres
    • psql
    • Dates
    • Interval
    • Rails
    • Ruby
    • Duration
    • Web
    • Database
  6. Sign up to receive a weekly recap from thoughtbot

Footer

thoughtbot
  • Services
  • Case Studies
  • Resources
  • Let's Talk
  • Our Company
  • Careers
  • Purpose
  • Blog
  • Sponsor
  • Mastodon
  • GitHub
  • Instagram
  • YouTube
  • Twitch
© 2024 thoughtbot, inc.

The design of a robot and thoughtbot are registered trademarks of thoughtbot, inc.

  • US: +1 (877) 9-ROBOTS
  • UK: +44 (0)20 3807 0560
  • Beware of fraudulent thoughtbot job listings Learn more
  • Code of Conduct
  • Accessibility Statement
  • Privacy Policy