06 - With() VS WithCount(): Out of RAM Memory?
33 - Use withCount When Just Counting
Let's look at a scenario where you must query the related records amount. A typical example would be loading the user with projects, and you need to show the amount of projects per user
Tutorial
7 min read
Free
Laravel Exceptions: How to Catch, Handle and Create Your Own
Quite often web-developers don't care enough about errors. If something goes wrong, you often see default Laravel texts like "Whoops, something went wrong" or, even worse, the exception code, which is not helpful at all to the visitor. So I decided to write a step-by-step article of how to handle errors in elegant way and present proper error information to the visitor.
Tutorial
7 min read
Premium
Eloquent Performance: 3 Most Common Mistakes
The performance of our applications is one of the top things we should care about. Inefficient Eloquent or DB queries are probably no.1 reason for bad performance. In this tutorial, I will show you the top 3 mistakes developers make when it comes to Eloquent performance, and how to fix them.
Haven't found what you're looking for?
Our team is here to help. Ask us anything about Laravel development and we'll get back to you with personalized guidance.
Tutorial
2 min read
Free
Eloquent withCount(): Get Related Records Amount
Eloquent has one less-known function called withCount(): it helps to get the amount of related records inside of the main object. It also works with two layers deep, inside of hasManyThrough relations. Let's take a look.
Video
7:35 mins
Free
Eloquent: Query 3-Level Relations with hasManyThrough and withCount
Another *practical* video of helping someone on Laracasts forum to query the data. This video has a "plot twist" where I decided to make my code even better.
Video
6:56 mins
Free
Laravel Performance: Careful with withCount()
An example of query optimization using withCount vs join, also adding cache on top.
Video
5:57 mins
Free
Eloquent withCount with Conditions and Aliases
To calculate the related records, we use withCount() in Eloquent. But there are a few "advanced" features I want to show you today.