The right tool for the right job, right? Well let me introduce you to psql.
Structs and maps are easy to work with in Elixir, but if they are stored in the database as JSON and accessed via an Ecto Schema, it’s not as clear how to query them. We’re going to explore how to do that, and make it clear and easy.
You can use PostgreSQL’s JSON data types to store embedded data on Ecto models. But the way Ecto tells you to store it might not be the best way.
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.
Write queries that combine data from multiple sources.
What do you do when indexes aren’t enough?
Take a guided tour through a query plan for a “simple” SQL query.
Improve query performance by using the right index type.
Database views can improve the performance, composability, and readability of
your rails application and Scenic is here to help.