Taming the N+1 Problem in Yii2 with Eager Loading
Eager loading with Yii2’s <code>with()</code> solves the N+1 query problem. Learn how to apply it, the trade‑offs, and a concrete example with articles, comments, and authors.
Loading…
ReadMeFeed / Community knowledge
#active-record
Real questions. Useful conversations. Find the people who know your stack.
Managing Database Logic with Yii Active Record
Learn how to use Yii's Active Record to replace manual SQL with object-oriented CRUD, automate model creation with Gii, and solve the N+1 query problem.
yiiPaginating Active Record Queries in Rails
Replace unbounded Active Record queries with paginated scopes to limit memory use and database load in Rails applications.
railsStop Storing Reset Tokens in Your Database: Using Rails generates_token_for
Stop cluttering your database with reset_token columns. Learn how Rails 7.1's generates_token_for creates signed, self-invalidating tokens for password resets and magic links.
Let Yii2 Behaviors Own Your Audit Fields: TimestampBehavior and BlameableBehavior in Practice
Stop setting created_at and created_by in controllers. Yii2's TimestampBehavior and BlameableBehavior move audit fields into the model—here's the configuration, a worked example, and the query-builder bypass you need to know about.
Catching N+1 Queries Early with Rails strict_loading
Learn how Rails 6.1's strict_loading mode turns lazy association loads into explicit errors, helping you spot N+1 problems before they hit production.
Yii2 Active Record vs Query Builder for Reports
When to use Query Builder versus Active Record in Yii2 for reporting queries, with a comparison table, trade-offs, and a monthly sales report example.
Reversible Rails Migrations with the `change` Method: A Practical Guide
Learn how to write reversible migrations in Rails using the `change` method, understand which operations are auto‑reversed, and discover how to handle irreversible commands safely.
Managing Many-to-Many Relationships with Rails has_many :through
Learn how to implement has_many :through in Ruby on Rails to manage complex many-to-many relationships that require metadata, validations, and eager loading.