Skip to main content
thoughtbot thoughtbot
  • We're live 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
We're live 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
Development
  • Ruby on Rails
  • Hotwire
  • AI and Machine Learning
  • Maintenance
  • Mobile
Design
  • Shaping Sprints
  • UX, UI, and Product Design
  • Design Systems
Product
  • MVP
  • Product Management
  • Accessibility
Team and Processes
  • Team Augmentation
  • Fractional Leadership
View all Services
  • Healthcare
  • Finance
  • Insurance
View all Resources
Development
  • Tech Leadership Resources
  • Open Source
  • Books
  • The Bike Shed Podcast
  • Live Streaming on YouTube
  • Conference Talks
The business of great software
  • Playbook
  • 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 partner for design and development.

    • All Topics
    • Design
    • Development
    • Product
    • More topics
  1. 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
  2. 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
  3. 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
  4. 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
  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
    • PostgreSQL
    • 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
    • PostgreSQL
  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. 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
    • PostgreSQL
    • SQL
    • Analytics
    • Rails
  9. 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
  10. 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
  11. Sign up to receive a weekly recap from thoughtbot

    Looking for even more ways to stay connected?
    RSS feed Check out our feeds
« First ‹ Prev 1 2 3 4 5 6 Next › Last »

Footer

thoughtbot
  • Services
  • Case Studies
  • Resources
  • Let's Talk
  • Our Company
  • Careers
  • Purpose
  • Blog
  • Events
  • Sponsor
  • Store
  • Mastodon
  • Bluesky
  • GitHub
  • YouTube
  • Twitch
  • Feeds
© 2026 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
  • Code of Conduct
  • Accessibility Statement
  • Privacy Policy