I’ve wrapped up my second Scala client project, and I enjoyed SQL.
The right tool for the right job, right? Well let me introduce you to psql.
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.
What do you do when indexes aren’t enough?
Take a guided tour through a query plan for a “simple” SQL query.
How can you plug complex, multi-model SQL queries into ActiveRecord models so that you can use them in your views?
Take your queries to the next level with window functions.
Use SQL EXPLAIN to understand when and why indexes are used (or not).
An in-depth overview of INSERT, SELECT, UPDATE, and DELETE statements,
ORDER BY, INNER JOIN, LEFT OUTER JOIN, WHERE, GROUP BY, and HAVING clauses,
and topics such as join tables and sub-queries.