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

PostgreSQL Articles

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

    • All Topics
    • Design
    • Web
    • iOS
    • Android
    • More topics
  1. 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
  2. Testing SQL Performance in PostgreSQL

    Measure query speed with Postgres’ EXPLAIN ANALYZE.

    Elisa Verna
    December 15, 2023
    • SQL
    • PostgreSQL
    • Performance
  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. 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
  5. 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
  6. 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
    • Rails
    • PostgreSQL
    • Active Record
  7. enum VS enum VS enum - Enumeration, Enumerator & Enumerable

    How do enums works in Ruby, and what they actually are.

    Fernando Marques
    October 4, 2022
    • Enum
    • Enumerable
    • Enumerator
    • Enumeration
    • Design Pattern
    • PostgreSQL
    • Ruby
    • Development
  8. 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