-
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.
-
Improve the speed of Postgres full-text search by introducing a tsvector column to cache lexemes and using a trigger to keep the lexemes up-to-date.
-
What is referential integrity and why is it important to your Rails apps?
Sign up to receive a weekly recap from thoughtbot