With Ecto, 🎶 you can always get what you want. And if you try sometimes, well, you might find, you can select want you need 🎶.
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).