Yii 2 ActiveRecord Optimistic Locking: Configuration and Limits
Enable Yii 2 ActiveRecord optimistic locking with a version column, handle StaleObjectException, and understand its limits for concurrent updates.
Loading…
ReadMeFeed / Community knowledge
#activerecord
Real questions. Useful conversations. Find the people who know your stack.
Solving the N+1 Query Problem in Yii2 ActiveRecord
Learn how to eliminate the N+1 query problem in Yii2 using ActiveRecord's eager loading capabilities to significantly improve database performance.
yiiWhen Your Join Table Needs Its Own Logic: Choosing has_many :through in Rails
Choose has_many :through when your many-to-many relationship carries data or behavior—like appointment dates, statuses, or notifications. The join model becomes a first-class Active Record object with validations, callbacks, and scopes, keeping domain logic where it belongs.
railsAccelerating Yii Development: Using Gii for Rapid Scaffolding
Stop writing repetitive CRUD boilerplate. Learn how to use Yii's Gii code generator to automate Model and Controller creation while avoiding common security pitfalls.
Choosing Between with() and joinWith() in Yii ActiveRecord: A Practical Guide
Yii's with() and joinWith() both solve N+1 queries but generate different SQL. with() uses separate IN queries and preserves pagination; joinWith() uses JOINs but multiplies rows for hasMany relations. Choose based on relation type, pagination needs, and column filtering requirements.
Accelerating Prototyping with Yii: Balancing Gii Scaffolding and ActiveRecord
Learn how to leverage Yii's Gii generator and ActiveRecord for rapid prototyping while avoiding common performance pitfalls like the N+1 query problem.
Choosing Between Offset and Cursor Pagination in Rails
Learn when to use Offset vs. Cursor-based pagination in Ruby on Rails to prevent database performance degradation as your datasets grow.
Rails 7.1 strict_loading: A Gradual Audit for Lazy Associations
Use Rails 7.1 strict_loading to surface lazy-loaded associations incrementally. Start with per-relation checks, move to per-model enforcement, and opt out intentionally lazy associations.
Diagnosing N+1 Queries in Yii 2 List Pages: A Practical Checklist
A diagnostic guide to finding and fixing N+1 queries in Yii 2 list pages, covering eager loading with with(), DataProvider pagination, and index checks.