See WHERE and SELECT visualized in this SQL primer.
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.