Solving the N+1 Problem in development

You launch a brand new app, announce it to the world, and the users start coming in. Then without warning the database is under huge load and you are frantically trying to figure out what is going on before the site locks up and people start screaming. What is the problem, you think to yourself? Ahh, that's right you forgot to check to see if you lazy-loaded queries causing bottlenecks. 

It's honestly easy to forget and the community has a few packages to help you track those down, like the Laravel Query Detector, Debugbar, and others. Up till now, nothing was built in, but coming next week is a brand new way to do this right in your Laravel app. It's called preventLazyLoading(), and when enabled anytime you attempt to lazy load it will throw an exception. This will be something that should help almost everyone. 

"One of Many" Eloquent Relationship

Speaking of the database, we also got a brand new "One of Many" relationship, that creates a one-to-one association from a one-to-many relationship. For example, “latest login,” “first login,” and product pricing (i.e., get the latest published price for a product). Here is a code sample that you would insert into your Model: 

$this->hasOne(Login::class)->latestOfMany();

Check out our post with more examples and more clarification.

Sublime Text 4
The first stable release of Sublime Text 4 is here with new features like Tab Multi-Select, Context-Aware AutoComplete, and more.

Find N+1 problems instantly by disabling lazy loading
Learn about the strict lazy loading setting that allows you to disable it entirely for non-production environments.

Sidecar package
Sidecar for Laravel packages deploys and executes AWS Lambda functions from your Laravel application.

Defining Default Password Validation Rules
The Password Validation Rule Object now supports the ability to define default password rules you can use across your application.

"One of Many" Eloquent Relationship
The one-of-many relationship creates a one-to-one association from a one-to-many relationship.

Laravel Nova Inline Select
Laravel Nova Inline Select allows you to change the status of the resource easily without having to edit. It can be used directly from both the index and detail views, saving a lot of time.

Sponsor

Scout APM: Leading Edge Performance Monitoring

Scout APM is Laravel application performance monitoring that uses tracing logic to tie bottlenecks to source code to help developers spend less time debugging and more time building. 

Scout’s easy installation and clutter-free UI streamlines identifying and resolving performance issues such as N+1 queries, memory leaks, and other abnormalities. See for yourself why Scout is a developer's best friend and start your free 14-day trial today, no credit card required! As an added bonus for Laravel News readers, Scout will donate $5 to the OSS project of your choice when you deploy your free trial.

Now Hiring

Full-Stack Laravel/Vue Developer(s) (Junior to Senior Level)
CC Marketing Inc. | Remote

Front-end Developer
XU Magazine | Leicester, Remote

Laravel Partner Seeks Web Application Developer
Kirschbaum Development Group, LLC | Remote

Mid/Senior Laravel Web Developer (Remote)
Raffle Nexus | Remote, Canada

Site Reliability Engineer
TEAM Professional Services Companies | Tulsa, OK

Full Stack Developer
Landscape | Remote

Full Stack Developer
Wise Publishing, Inc | Remote, Toronto, ON Only

Laravel Web Developer
Formworks Cloud | Stamford, UK

Software Engineer (PHP, Laravel)
Spire Collective | Remote

Senior Software Engineer (PHP, Laravel)
Lurn Inc. | Remote

Senior PHP/Laravel Engineer
GoCollect, LLC | Charlotte, NC

Remote PHP back-end engineer with a passion for gaming (f/m/x)
madewithlove | Remote

Full Stack Developer (Mid-Senior)
StartCHURCH | Remote, Georgia and Florida only

Full-stack Engineer (Laravel, React)
BuildStream | Remote

Senior Backend Laravel Engineer
Rally | Remote

Developer/Frontend
ComplYant | Remote

Laravel Developer
SUMO Webworks | Remote (North America Only)

Senior Backend PHP Developer (m/f/d) - onsite or remote in Germany
ABOUT YOU AG & Co. KG | HQ Hamburg or remote (within Germany)

PHP Laravel Developer - Join our Travel Family!
Fox World Travel | Remote

Laravel Developer
Parcelytics | Remote

Senior Backend PHP Developer
Raketech Group Ltd. | Remote

Mid/Senior Developer (PHP, Laravel, WordPress)
Whistle Stop Digital | DC / Dallas / Remote, USA Only

Laravel Developer
Global Protection Corp. | Remote

Technical Lead
Street Group | Manchester, UK (Partially remote)

Developer with SAML experience
Protocol Policy Systems | Remote

Passionate Learner to help build a more sustainable world - Reuse Repair Rethink
Revive | Remote or Cologne Germany

Post a job on LaraJobs and it'll be featured here in next week's newsletter. 

Community Links

Larastreamers - Laravel Streaming Directory
larastreamers.com

Antlers Language for Statamic - Visual Studio Code Extension
antlers.dev

Refactor If else Statement With Polymorphism, Also following SO of SOLID Principle
www.youtube.com

Specifying MySQL Index Size in Laravel
adithya.dev

Configure Your Laravel Queues with AWS SQS
www.codecheef.org

How to Use Alpine JS with Laravel
techvblogs.com

Setting Up Lumen and MySQL With Docker - Part II
yossiabramov.com

Laravel Deep Dive - Let's see why User::get() and User::query()->get() give the same result
youtu.be

The PHP switch statement - PHP fundamentals
www.csrhymes.com

Building Earthquake API with Laravel
ilyasozkurt.com

Anonymous Classes In PHP - Full PHP Course - PHP 8
youtu.be

How to Deploy Laravel Project with Apache and Linux Server
www.codecheef.org

Laravel 8.x Follow Unfollow Example From Scratch
www.codecheef.org

Laravel 8.x Custom Login and Registration Example
www.codecheef.org

Working Through A Pandemic
tighten.co

Send Mail to Inactive User with Cron Jobs in Laravel
www.codecheef.org

15 Random Laravel Snippets & Methods
rappasoft.com

Custom Access Tokens in Laravel Sanctum
doeken.org

ReFactoring Helper Functions to Static Class Methods In Laravel
www.codecheef.org

Laravel - Sweet Alert Confirm Delete Example
www.mywebtuts.com

How to add Custom Reset Password Functionality in Laravel?
www.itsolutionstuff.com

Bootstrap 5 Installation on Laravel along with Utility API Example
www.youtube.com

Laravel 8 Roles and Permissions Without Package
www.codecheef.org

How to use Tailwind CSS with Laravel
techvblogs.com

Getting started with Laravel Passport and OAuth2
www.youtube.com

React Redux Complete Setup Example with Api Call
www.codecheef.org

OOP PHP Traits - What are traits, how they work and its downsides - Full PHP Course - PHP 8
youtu.be

Offset vs Cursor Pagination in Laravel [In-Depth Guide]
www.laravel-enlightn.com

Generate and autoload custom Helpers, Builder Scope, Service class, Trait
github.com

Laravel Auto Routes
github.com

Laravel Inotify
github.com

Integrate with Button down Email from Laravel
github.com

Livewire Modal Twitter
github.com

bastinald/laravel-livewire-auth
github.com

Eliminate frictions from the developers’ experience – discover the new Inspector data visualization UI
inspector.dev

Laravel Users: Set Locations/Teams with Breeze [VIDEO]
www.youtube.com

Advanced Laravel Code Review: Daybreak - Complex Jetstream-Based Structure [VIDEO]
www.youtube.com

Laravel Eloquent Relationships Explained
www.youtube.com

5 Tools to Quickly Run Laravel Commands with Tinker [VIDEO]
www.youtube.com

From the archive

Handling Signals in Laravel Console Commands
Laravel Artisan commands can now handle signals through Symfony's signal handling features. Learn more about how to handle signals in Laravel console commands. 

Using Laravel translations in Javascript with the Laravel Translations Loader
Have you ever wanted to use the same Laravel translations you use on the back-end in your front-end code, like Vue.js, Angular? This package allows you to do just that! 

Laravel Forge now has support for Laravel Octane
Today, Laravel Forge adds official Laravel Octane support. 

Quick Tip: Unit Testing JSON Columns in Laravel
You can use a column->key syntax in Laravel tests when asserting that the database has certain JSON data 

How to override login redirects in Jetstream or Fortify
In this tutorial, learn how to override login redirects in Laravel Jetstream and Laravel Fortify 

Keep Logs Tidy With the Log Cleaner Package for Laravel
Laravel Log Cleaner is a package by Joost van Veen for keeping your log files small and tidy. 

Trackable Jobs for Laravel
Trackable Jobs for Laravel is a package by Mateus Junges that allows you to track Laravel jobs in your database easily. 

Last Year

Push deploy a Laravel app for free with GitHub Actions
Configuring push deploys is super easy to do yourself — and free! In this tutorial, learn how to do it with GitHub actions. 

Introducing PestPHP: Screencast Series by by Michael Dyrynda
Introducing Pest is a video series by Michael Dyrynda that walks you through setting up and using PestPHP, a new testing framework by Nuno Maduro

PestPHP Released as Open-Source
Console legend Nuno Maduro has open-sourced Pest, an elegant PHP testing framework that focuses on simplicity. 

Laravel 7.12 Released
The Laravel team released v7.12.0 with a new TrustHosts middleware, along with the latest updates to the 7.x branch. 

Laravel Podcast Season Four is now on Youtube
Season four of the Laravel Podcast has already started publishing new episodes out and today Matt has started pushing the audio over to Youtube as well. This move will allow you to Airplay episodes, have comments, and all the other benefits that come with Youtube. 

Time Travel PHP Library
Travel is a small PHP library by Rachid Laasri that wraps around Carbon PHP to help you travel to a specific point in time and back again in a simple, readable way. Just released a small PHP package to help you work with dates in your tests. 

Two Years ago

Laravel Views now support html as a file type in v5.8.18
The Laravel team released Laravel 5.8.18 with HTML as a valid extension option for views. 

Laravel Enum Package for Generating enum-php Classes
Laravel Enum by Andrea Marco Sartori is a Laravel package for generating enum-php classes. 

Add API Keys to Your Laravel Models with Laravel Keyable
Laravel Keyable is a package by Liran Cohen that enables you to add API keys to any model and associate incoming requests with their respective model. 

PHP Insights
PHP Insights is the perfect starting point to analyze the code quality of your PHP projects. Carefully crafted to simplify the analysis of your code directly from your terminal.