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

  2. Have Some (Referential) Integrity with Foreign Keys

    What is referential integrity and why is it important to your Rails apps?

    Derek Prior

  3. Postgres Window Functions

    Take your queries to the next level with window functions.

    Simon Taranto

  4. Why Postgres Won't Always Use an Index

    Use SQL EXPLAIN to understand when and why indexes are used (or not).

    Simon Taranto

  5. An Explained psqlrc

    Let’s walk through my short psqlrc(5) to see what I’ve set, and to inspire...

    Mike Burns

  6. Avoid the Three-state Boolean Problem

    Use null: false, default: false on boolean columns in ActiveRecord migrations to avoid NULL problems.

    Gabe Berke-Williams

  7. Improving the Command-Line Postgres Experience

    Understanding the ~/.psqlrc configuration file, its options, and reading...

    Gabe Berke-Williams

  8. Implementing Multi-Table Full Text Search with Postgres in Rails

    Easily searching across an application’s data is a pervasive need. If you are...

    Caleb Thompson and Derek Prior

  9. How to Create Postgres Indexes Concurrently in ActiveRecord Migrations

    By default, Postgres locks writes (but not reads) to a table while creating...

    Dan Croak

  10. The Perils of Uniqueness Validations

    Your Rails application probably makes use of uniqueness validations in...

    Derek Prior

Sign up to receive a weekly recap from Giant Robots