Learn how to create and implement a row level security policy in Rails, allowing to limit the database rows a user can access.| pganalyze
We create domain types and composite types in PostgreSQL and show how to hook into the Rails Attributes API to help instantiate them as objects that Ruby can use.| pganalyze
This article compares PostGIS in Rails with Geocoder and highlights areas where you'll want to (or need to) reach for one over the other. Learn more here.| pganalyze
Active Record lets you access raw SQL. We look at 5 business requests for data, translate them into SQL, then into Rails code to find the requested data.| pganalyze
This article shows how to optimize a Full Text Search implementation with Rails and PostgreSQL, taking a single query from 130ms to 7ms.| 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