PostgreSQL - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
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
Advanced Postgres Performance Tips

What do you do when indexes aren’t enough?
Caleb Hearth
July 29, 2016
- PostgreSQL
- Databases
- SQL
- Performance
Reading a Postgres EXPLAIN ANALYZE Query Plan

Take a guided tour through a query plan for a “simple” SQL query.
Caleb Hearth
July 26, 2016
- PostgreSQL
- Databases
- SQL
- Performance
Postgres Index Types

Improve query performance by using the right index type.
Calle Erlandsson
April 21, 2016
- PostgreSQL
Announcing Scenic - Versioned Database Views for Rails

Database views can improve the performance, composability, and readability of your rails application and Scenic is here to help.
Derek Prior
January 11, 2016
- PostgreSQL
- Rails
- Web
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