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

Databases Articles

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

    • All Topics
    • Design
    • Web
    • iOS
    • Android
    • More topics
  1. This Week in #dev (Feb 9, 2024)

    Speed up your tests, a nice SQL trick, and a Jest global that you might not know about.

    thoughtbot
    February 19, 2024
    • This Week In Dev
    • Databases
    • Rails
    • Testing
    • Jest
    • Performance
  2. This Week in #dev (Jan 26, 2024)

    Inserting 100,000,000 rows into the database, how Turbo can break OAuth forms, and more!

    thoughtbot
    February 5, 2024
    • This Week In Dev
    • Rails
    • Databases
    • Hotwire
  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. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  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

1 2 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