-
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...
-
I recently upgraded Postgres on my development machine from 9.1.4 to 9.2.1.
...
Sign up to receive a weekly recap from thoughtbot