-
How do you even save a “duration”, let alone query for records by that value? It’s actually easier than you think.
-
A quick introduction to which database index types are right for the task at hand in Postgresql.
-
Finally, you too can understand how to use GROUP BY in your SQL queries.
-
A mental model to understand SQL’s JOIN.
-
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 🎶.
-
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.