PostgreSQL - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
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
Full-text search with PostgreSQL and Action Text

Search through user-provided HTML content with PostgreSQL and Active Record.
Sean Doyle
May 17, 2021
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
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
Back to basics: psql

The right tool for the right job, right? Well let me introduce you to psql.
German Velasco
March 14, 2019
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
- PostgreSQL
- JSON
- Elixir
- Query
- Web
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
- PostgreSQL
- JSON
Better Date Manipulation in PostgreSQL Queries

Use interval and date_trunc to make working with SQL dates easier.
Derrick Carr
September 19, 2017
- PostgreSQL
- SQL
- Data
- Web
Querying the oldest and newest records within an SQL group

How to find the oldest or most recent record associated with a particular foreign key.
Jack Wilson
September 18, 2017
- PostgreSQL
- SQL
- Databases
- Rails
PostgreSQL's Foreign Data Wrapper

Write queries that combine data from multiple sources.
George Brocklehurst
October 28, 2016
- PostgreSQL
Sign up to receive a weekly recap from thoughtbot

Your email address

Looking for even more ways to stay connected?

Check out our feeds

Sign up to receive a weekly recap from thoughtbot