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.
What is referential integrity and why is it important to your Rails apps?
Take your queries to the next level with window functions.
Use SQL EXPLAIN to understand when and why indexes are used (or not).
Let’s walk through my short psqlrc(5) to see what I’ve set, and to inspire...
Use null: false, default: false on boolean columns in
ActiveRecord migrations to avoid NULL problems.
Understanding the ~/.psqlrc configuration file, its options, and
reading...
Easily searching across an application’s data is a pervasive need. If you are...
By default, Postgres locks writes (but not reads) to a table while creating...
Your Rails application probably makes use of uniqueness
validations
in...