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. 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
    • Postgres
    • Action Text
    • Active Record
  2. 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
    • Postgres
    • macOS
  3. 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
  4. Back to basics: psql

    The right tool for the right job, right? Well let me introduce you to psql.

    German Velasco
    March 14, 2019
    • psql
    • Postgres
    • SQL
    • Back To Basics
  5. Querying an Embedded Map in PostgreSQL with Ecto

    Structs and maps are easy to work with in Elixir, but if they are stored in the database as JSON and accessed via an Ecto Schema, it’s not as clear how to query them. We’re going to explore how to do that, and make it clear and easy.

    David Bernheisel
    March 9, 2018
    • Ecto
    • Map
    • Embeds One
    • Postgres
    • JSON
    • Elixir
    • Query
    • Web
  6. Why Ecto's Way of Storing Embedded Lists of Maps Makes Querying Hard

    You can use PostgreSQL’s JSON data types to store embedded data on Ecto models. But the way Ecto tells you to store it might not be the best way.

    Jon Yurek
    February 16, 2018
    • Elixir
    • Ecto
    • Postgres
    • JSON
  7. Better Date Manipulation in PostgreSQL Queries

    Use interval and date_trunc to make working with SQL dates easier.

    Derrick Carr
    September 19, 2017
    • Postgres
    • SQL
    • Data
    • Web
  8. Querying the Oldest and Newest Records Within a SQL Group

    How to find the oldest or most recent record associated with a particular foreign key.

    Jack Wilson
    September 18, 2017
    • Postgres
    • SQL
    • Databases
    • Rails
  9. PostgreSQL's Foreign Data Wrapper

    Write queries that combine data from multiple sources.

    George Brocklehurst
    October 28, 2016
    • Postgres
  10. Advanced Postgres Performance Tips

    What do you do when indexes aren’t enough?

    Caleb Hearth
    July 29, 2016
    • Postgres
    • Databases
    • SQL
    • Performance
  11. Sign up to receive a weekly recap from thoughtbot

« First ‹ Prev 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