Does it provide advice on safe database migrations?

Yes, it includes patterns for concurrent indexing and multi-step column removal to ensure migrations don't lock tables or cause downtime in production.

Does this skill support older versions of Ruby on Rails?

The patterns are optimized for Rails 7+, but many of the core ActiveRecord concepts and optimization techniques are backward compatible with Rails 6.x and 5.x.

Does it cover complex SQL needs?

Yes, it includes guidance on using Arel for complex query building that exceeds the standard ActiveRecord interface.

How does this help with N+1 query problems?

It provides clear code examples and logic for when to use includes, preload, or eager_load to ensure your application fetches data efficiently in a single trip to the database.

Can it help me move logic out of ActiveRecord callbacks?

Absolutely. It promotes the use of service objects and explicit transaction management to keep your models lean and your business logic maintainable.

Rails ActiveRecord Optimization Patterns

Name: Rails ActiveRecord Optimization Patterns
Author: betamatt

bybetamatt

Database Management

Optimizes Ruby on Rails database interactions with production-grade ActiveRecord patterns and performance best practices.

About

This skill provides expert guidance for Rails 7+ developers to write efficient, scalable, and safe database queries. It covers critical areas such as solving N+1 query problems through eager loading, implementing safe zero-downtime migrations, managing complex associations, and utilizing performance-oriented features like counter caches and batch processing. It is an essential resource for refactoring legacy code for performance or designing new database schemas intended for high-traffic production environments.

Key Features

Guidance on safe callback patterns and robust transaction management
Production-safe migration patterns for zero-downtime deployments
Advanced association management including counter caches and polymorphic links
Efficient batch processing techniques for large dataset manipulation
Comprehensive N+1 query detection and resolution strategies
0 GitHub stars

Use Cases

Implementing complex database queries using Arel and composable scopes
Diagnosing and fixing performance bottlenecks in existing Rails applications
Refactoring business logic from model callbacks into explicit service objects

About

Key Features

Guidance on safe callback patterns and robust transaction management
Production-safe migration patterns for zero-downtime deployments
Advanced association management including counter caches and polymorphic links
Efficient batch processing techniques for large dataset manipulation
Comprehensive N+1 query detection and resolution strategies
0 GitHub stars

Use Cases

Implementing complex database queries using Arel and composable scopes
Diagnosing and fixing performance bottlenecks in existing Rails applications
Refactoring business logic from model callbacks into explicit service objects