Add comments to SQL queries made by Laravel
We've released a new package called spatie/laravel-sql-commenter. This one can add comments to SQL queries. These comments allow you to easily pinpoint the origin of a query when looking at your query log.
Posts tagged with database
New UUID formats
There are a couple of nice ideas there to solve longstanding problems with UUIDs
Read more [www.ietf.org]
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.
"Freek’s newsletter is one of the best ways to stay updated with the Laravel and PHP ecosystem. It consistently highlights useful packages, tools, and ideas from the community, especially the amazing work coming from Spatie. As a Laravel developer building SaaS and web platforms, I find it extremely helpful to discover practical tools and insights that improve my development workflow."
The value of a good database design
– tray2.se - submitted by Patrik Ahlström
You might think that the way your store your data isn't really that important. Well it's more important than you think it is. A good database design just like good clean code is the key to performance, not only for the end user but also for you the developer. A poor database model just like poorly written code will slow you down and furthermore it will slow your database queries down which results in a slow application.
Read more [tray2.se]
Common SQL errors for Laravel Developers
– tray2.se - submitted by Patrik Ahlström
I hope you won't run into any of these.
Read more [tray2.se]
Composable seeders in Laravel with callOnce
Laravel 9 is fresh out the door, and it contains a small contribution of mine: a new callOnce method for database seeders.
Read more [sebastiandedeyne.com]
Efficient Pagination Using Deferred Joins
– aaronfrancis.com - submitted by Aaron Francis
A slight modification to traditional offset/limit pagination that can drastically boost performance.
Read more [aaronfrancis.com]
Bitmasking in Laravel and MySQL
– aaronfrancis.com - submitted by Aaron Francis
An introduction to using bitmasks in general, and their usage in PHP, Laravel, and MySQL.
Read more [aaronfrancis.com]
Increase Database Performance By Using Multiple Columns
By thinking outside of the box, you can often get much faster database performance by splitting values across multiple database columns.
Read more [downing.tech]
Efficient Distance Querying in MySQL
– aaronfrancis.com - submitted by Aaron Francis
A clever use of MySQL indexes and generated columns to make blazing fast geolocation searches.
Read more [aaronfrancis.com]
Database and Eloquent ORM: New features and improvements since the original Laravel 8 release (1/2)
– protone.media - submitted by Pascal Baljet
In this series, I show you new features and improvements to the Laravel framework since the original release of version 8. This week is about the Database and Eloquent features in Laravel 8.
Read more [protone.media]
Ensuring data(base) consistency during concurrent requests
– blog.frankdejonge.nl - submitted by Robin Dirksen
Bugs caused by race conditions can be a huge source or frustration. They are difficult to identify and often difficult to remedy.
Read more [blog.frankdejonge.nl]
How to update large data in Laravel
Here are a few best practices for working with a large tables.
Read more [42coders.com]
Strategies for decreasing the number of queries in a Laravel app original
Oh Dear is all-in-one solution to monitor your site that my buddy Mattias Geniar and I have created. It can monitoring uptime, certificates, broken links, scheduled jobs, and much more.
Under the hood, Oh Dear is a large Laravel application that performs many queries all of the time. To power future features, we've recently changed our database structure and refactored some pieces in our code base. We increased performance by decreasing the number of queries.
In this blog post, we'd like to to share some techniques that might be helpfull to increase the performance of your Laravel app too.
How Laravel handles DB connections
Mohammed Said created another kick ass video, this time on how Laravel handles DB connections.
How to optimize ORDER BY RANDOM()
Tobias explains how you can make this operation very fast even if your table has several million records.
Read more [tpetry.me]
Offset vs Cursor Pagination in Laravel
– www.laravel-enlightn.com - submitted by Paras Malhotra
An in-depth guide on offset and cursor pagination in Laravel, and the pros and cons of each.
Read more [www.laravel-enlightn.com]
Laravel Worldwide Meetup #8: Using Vite in Laravel & How to optimize your DB indexes original
Here's the recording of Laravel Wordwide Meetup #8. My guests for this edition were Kai Sassnowski talking on the importance of DB indexes, and Sebastian De Deyne on how to use Vite in Laravel.
Why and how you should remove inactive users and teams original
There are many SaaS applications that allow potential new customers to try out the service using a trial period. Of course, not everybody will convert. After the trial period is over, some people will not use the service anymore. However, if nothing is being done about it, their email address and…
Laravel Media Library: Load Only 1st Picture Efficiently
– naxon.dev - submitted by Daniel Naxon
I needed to display only the first picture from my Product's model media collection and found my app running five queries and hydrating 16 models with only four products to display 😱 . Here's how I ended with only two queries and eight models.
Read more [naxon.dev]
Using Laravel's new Query Builder Upsert feature
– atymic.dev - submitted by atymic
Overview of the new upsert feature in Laravel 8.10, how to use it and some tips.
Read more [atymic.dev]
