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

Postgres Articles

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

    • All Topics
    • Design
    • Web
    • iOS
    • Android
    • More topics
  1. 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
    • Error Handling
    • API
    • Distributed Systems
    • Fault Tolerance
    • Postgres
  2. 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
  3. 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
    • Postgres
  4. 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
    • Postgres
    • Databases
    • Rails
  5. This week in #dev (Mar 24, 2023)

    It’s all about databases in this edition!

    thoughtbot
    April 7, 2023
    • This Week In Dev
    • Active Record
    • Postgres
    • Databases
  6. Handling external API errors: A resumable approach

    Clarifying a few possible ways to implement resumable workflows when working with external APIs.

    Thiago Araújo Silva
    January 24, 2023
    • Error Handling
    • API
    • Distributed Systems
    • Postgres
  7. Detect anomalies in user behavior using Rails and PostgreSQL

    You probably use some type of error monitoring software to notify you when an exception is raised in your application, but are you being notified when there is an anomaly in user behavior?

    Steve Polito
    September 29, 2022
    • Postgres
    • SQL
    • Analytics
    • Rails
  8. 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
    • Postgres
    • Active Record
    • SQL
  9. 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
  10. Choosing the right database index type

    A quick introduction to which database index types are right for the task at hand in Postgresql.

    Greg Fisher
    December 16, 2021
    • Postgres
    • SQL
    • Databases
    • Performance
  11. Sign up to receive a weekly recap from thoughtbot

1 2 3 4 5 Next › Last »

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