SQL performance improvements: finding the right queries to fix
At Oh Dear, my colleague Mattias recently vastly increased the performance of our service. Here's how he did it.
Read more [ohdear.app]
At Oh Dear, my colleague Mattias recently vastly increased the performance of our service. Here's how he did it.
Read more [ohdear.app]
You can now use our MCP server to connect your AI agent to Flare. This way your AI has all context it needs to diagnose and fix production and performance problems of your PHP, JavaScript and Laravel projects.
In this blog post I’d like to tell you how you can use it, and how it works under the hood.
Read more [flareapp.io]
Join 9,500+ smart developers
Get my monthly newsletter with what I learn from running Spatie, building Oh Dear, and maintaining 300+ open source packages. Practical takes on Laravel, PHP, and AI that you can actually use.
No spam. Unsubscribe anytime. You can also follow me on X.
"If you are one of the *millions* who have downloaded a Spatie package, then you understand the quality that Freek aims for. The newsletter is of the same quality of any Spatie package you're using."
– nabilhassen.com - submitted by Nabil Hassen
The new scout:queue-import command splits your model’s ID range into chunks and queues jobs for each, enabling faster indexing of large datasets.
Read more [nabilhassen.com]
– ryangjchandler.co.uk - submitted by Ryan Chandler
SQLite's WAL mode makes using SQLite database much more production-ready.
Read more [ryangjchandler.co.uk]
At Laracon US Caleb Porzio announced Livewire 4, which comes with unified components, performance improvements, and many more awesome goodies
Read more [devdojo.com]
– tighten.com - submitted by Kayla Helmick
Learn how to use SQL generated columns and database views in Laravel to simplify queries, boost performance, and make your data easier to filter, sort, and reuse across your application.
Read more [tighten.com]
Some interesting thoughts about caching.
Read more [buttondown.com]
A nice touch by Joel Clermont
Read more [masteringlaravel.io]
A bottleneck isn’t inherently bad, we all have them. What matters is making sure your biggest bottleneck is always working at it’s most optimal conditions. That’s where your optimizations should be focused.
Read more [benmckay.com]
Tests performed by Tideways show that, in general, the performance between 8.2, 8.3 and 8.4 does not move much for a Laravel, Symfony and WordPress demo application.
Read more [tideways.com]
We'll cover resizing, image optimization, and UI enhancements and show how Spatie's packages and products can make the whole process easier, more efficient, and even a bit fun.
Read more [spatie.be]
Laravel’s new fillAndInsert() method enables bulk insertions while applying model casting, timestamps, and UUID generation.
Read more [www.harrisrafto.eu]
– aaronfrancis.com - submitted by Aaron Francis
Transforming and serving images from Laravel in a cache-friendly way.
Read more [aaronfrancis.com]
– www.youtube.com - submitted by Pascal Baljet
Learn how you can update an Inertia.js page in real-time using client-side visits—without overloading your server, even with many users online. Laravel Echo, Laravel Reverb, and a new Inertia v2 feature make it simple and efficient.
Read more [www.youtube.com]
– stephenjude.me - submitted by STEPHEN JUDE
Read more [stephenjude.me]
– youtu.be - submitted by Bert De Swaef
This simple step-by-step guide teaches you how to deploy your Laravel project to Laravel Cloud! We'll cover everything from setup to handling queues for background tasks.
What you'll learn: ✅ Deploying a Laravel project to the cloud ✅ Setting up and managing queues ✅ Optimizing performance for scalability
Read more [youtu.be]
– jonathanpurvis.co.uk - submitted by Jon Purvis
Inspired by a Tweet from Christoph Rumpel asking for best practises for importing huge CSV files, I did a write up about how I've imported (so far) 1.7 billion rows of CSV data from Stripe using their API.
Read more [jonathanpurvis.co.uk]
– medium.com - submitted by Mazen Touati
Tackling scalability challenges unorthodoxly in large monoliths with strategies like multi-application infrastructure, circuit fuse, and hybrid DB optimization.
Read more [medium.com]
By implementing rate limiting at the edge, “dead requests” can be reduced.
Read more [james.brooks.page]
– infinitypaul.medium.com - submitted by Paul Edward
Here's how a unsuspicious validation rule can wind up making your app slower.
Read more [infinitypaul.medium.com]