Buka Corner

Sign in Subscribe

Eloquent ORM

Avoiding the N+1 Query Trap in Laravel with withCount()

Avoiding the N+1 Query Trap in Laravel with withCount()

When working with Laravel Eloquent, one of the most common performance pitfalls is the N+1 query problem—and it often happens without developers realizing it. Imagine you're displaying a list of blog posts along with the number of comments each one has. You might think this is

Laravel Tip: firstWhere() vs where()->first() – Which One Should You Use?

Laravel Tip: firstWhere() vs where()->first() – Which One Should You Use?

When working with Eloquent in Laravel, you’ve likely come across two ways to fetch the first matching model from the database: Currency::where('code', 'CAD')->first(); or Currency::firstWhere('code', 'CAD'); At first glance, they seem interchangeable—and for

Why I Will Always Love Model::query() in Laravel — And You Should Too

Why I Will Always Love Model::query() in Laravel — And You Should Too

There’s a special place in my heart for one of Laravel’s most elegant and powerful features: Model::query(). As a PHP developer, especially one who works a lot with Eloquent ORM, I’ve come to appreciate how much control, flexibility, and readability this one little method offers. The

Using Virtual Columns in Laravel Queries and Filtering with HAVING

Using Virtual Columns in Laravel Queries and Filtering with HAVING

When working with Laravel’s Eloquent ORM, you may sometimes need to add virtual columns to your query results—columns that don’t exist in your database table but are generated dynamically. A common use case is adding a constant value, a computed field, or even an aggregated result. One

Optimizing MySQL LIKE Queries: Handling Trailing Spaces and Improving Search Accuracy

Optimizing MySQL LIKE Queries: Handling Trailing Spaces and Improving Search Accuracy

When implementing search functionality in a Laravel application using Eloquent, it's common to allow users to search for names, emails, or other fields using the LIKE operator in MySQL. However, trailing spaces in the search input can cause unexpected mismatches, leading to a poor user experience. Understanding the

Optimizing Your Eloquent Queries: Retrieving Only the Data You Need

Optimizing Your Eloquent Queries: Retrieving Only the Data You Need

When working with Laravel's Eloquent ORM, it's common to fetch related records based on a specific condition. However, many developers unknowingly retrieve entire model objects when they only need a single field. This not only wastes memory but also slows down queries, especially when dealing with

Optimizing Laravel Queries: Eager Loading vs Lazy Loading

Optimizing Laravel Queries: Eager Loading vs Lazy Loading

When working with Laravel's Eloquent ORM, you might frequently encounter the terms eager loading and lazy loading. These concepts directly impact the performance of your application, especially when dealing with related database models. Understanding Lazy Loading (Default Behavior) By default, Eloquent uses lazy loading, which means related models