-
Use interval
and date_trunc
to make working with SQL dates easier.
-
How to find the oldest or most recent record associated with a particular foreign key.
-
Write queries that combine data from multiple sources.
-
What do you do when indexes aren’t enough?
-
Take a guided tour through a query plan for a “simple” SQL query.
-
Improve query performance by using the right index type.
-
Database views can improve the performance, composability, and readability of
your rails application and Scenic is here to help.
-
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.