-
With Ecto, 🎶 you can always get what you want. And if you try sometimes, well, you might find, you can select want you need 🎶.
-
Re-use collection query logic within model instances to avoid duplication and get the best performance.
-
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.