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
Development
  • Ruby on Rails
  • Hotwire
  • AI and Machine Learning
  • Maintenance
  • Mobile
Design
  • Discovery Sprints
  • UX, UI, and Product Design
  • Design Systems
Product
  • MVP
  • Product Management
  • Accessibility
Team and Processes
  • Team Augmentation
  • Fractional Leadership
View all Services
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
  • Purpose Built
  • 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. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
    • PostgreSQL
    • SQL
    • Databases
    • Performance
  8. Full-text search with PostgreSQL and Action Text

    Search through user-provided HTML content with PostgreSQL and Active Record.

    Sean Doyle
    May 17, 2021
    • Rails
    • PostgreSQL
    • Action Text
    • Active Record
  9. Debugging a missing PostgreSQL connection on macOS

    could not connect to server: No such file or directory. Is the server running locally and accepting connections on Unix domain socket?

    Mike Burns
    October 14, 2020
    • Web
    • PostgreSQL
    • macOS
  10. Recurring Events and PostgreSQL

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

    Jonas Meinerz
    March 24, 2020
    • PostgreSQL
    • Dates
    • Interval
    • Rails
    • Ruby
    • Duration
    • Web
    • Databases
  11. Sign up to receive a weekly recap from thoughtbot

    Looking for even more ways to stay connected?
    RSS feed icon 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
  • Sponsor
  • Mastodon
  • Bluesky
  • GitHub
  • YouTube
  • Twitch
  • Feeds
© 2025 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