PostgreSQL - Giant Robots Smashing Into Other Giant Robots

- All Topics
- Design
- Development
- Product
- More topics
Optimizing Full Text Search with Postgres tsvector Columns and Triggers

Improve the speed of Postgres full-text search by introducing a tsvector column to cache lexemes and using a trigger to keep the lexemes up-to-date.
Dan Croak
June 25, 2015
- Web
- Rails
- PostgreSQL
Have Some (Referential) Integrity with Foreign Keys

What is referential integrity and why is it important to your Rails apps?
Derek Prior
December 2, 2014
- Web
- Rails
- PostgreSQL
Postgres Window Functions

Take your queries to the next level with window functions.
Simon Taranto
September 16, 2014
- Web
- Performance
- PostgreSQL
- SQL
Why Postgres Won't Always Use an Index

Use SQL EXPLAIN to understand when and why indexes are used (or not).
Simon Taranto
July 25, 2014
- Web
- Performance
- PostgreSQL
- SQL
An Explained psqlrc

Let’s walk through my short psqlrc(5) to see what I’ve set, and to inspire...
Mike Burns
July 24, 2014
- Web
- PostgreSQL
Avoid the Three-state Boolean Problem

Use null: false, default: false on boolean columns in ActiveRecord migrations to avoid NULL problems.
Gabe Berke-Williams
February 24, 2014
- Web
- PostgreSQL
Improving the Command-Line Postgres Experience

Understanding the ~/.psqlrc configuration file, its options, and reading...
Gabe Berke-Williams
November 30, 2013
- Web
- PostgreSQL
Implementing Multi-Table Full Text Search with Postgres in Rails

Easily searching across an application’s data is a pervasive need. If you are...
Derek Prior and Caleb Hearth
August 16, 2013
- Web
- PostgreSQL
- Rails
How to Create Postgres Indexes Concurrently in ActiveRecord Migrations

By default, Postgres locks writes (but not reads) to a table while creating...
Dan Croak
July 30, 2013
- Web
- PostgreSQL
- Ruby
The Perils of Uniqueness Validations

Your Rails application probably makes use of uniqueness validations in...
Derek Prior
July 17, 2013
- Web
- Rails
- 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