Learn to optimize a Full Text Search implementation with Django and Postgres. Even on a small table, we bring query execution time down from 0.045s to 0.001s.| pganalyze
We look at how to utilize both, views and materialized views, within Ruby on Rails with a real-world sized dataset of hockey teams and their top scorers.| pganalyze
We look into the pg_trgm extension, seeing first what trigrams actually are, and then how we can practically use similarity functions and operators in our Rails apps.| pganalyze
We discuss what N+1 queries are, how they are easily produced in GraphQL, and how to solve them using the graphql-batch gem along with a few custom batch loaders.| pganalyze
Migrations are a feature of Active Record that allows you to evolve your database schema over time. Rather than write schema modifications in pure SQL, migrations allow you to use a Ruby Domain Specific Language (DSL) to describe changes to your tables.After reading this guide, you will know: Which generators you can use to create migrations. Which methods Active Record provides to manipulate your database. How to change existing migrations and update your schema. How migrations relate to sch...| Ruby on Rails Guides