Eloquent Query Classes Pattern
– wendelladriel.com - submitted by Wendell Adriel
Learn how to use Eloquent Query Classes to organize important database logic in Laravel without adding a full repository layer.
Read more [wendelladriel.com]
Posts tagged with database
Lock a shared test database for parallel test processes
AI coding agents love to run tests in parallel processes.
That's great until multiple processes try to use the same local test database at once. A small file lock can serialize access and stop those runs from stepping on each other.
Read more [rias.be]
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 publishes a super resourceful and practical newsletter. A must for anyone in the Laravel space"
Run seeders from migrations
A practical look at why you should populate essential data from migrations instead of seeders. Once your app is live, manually running seeders becomes a deployment risk. Migrations are deterministic, automatic, and roll back cleanly.
Read more [spatie.be]
Laravel Site Search v3 is here: crawl and search your entire site using just your database original
We're proud to release v3 of laravel-site-search, a package that crawls and indexes your entire site. Think of it as your own private Google. Point it at a URL, let it crawl every page, and get full-text search results back.
Previous versions required Meilisearch as the search engine. That works well, but it means running a separate service.
With v3, your application's own database is all you need. It supports SQLite, MySQL, PostgreSQL, and MariaDB out of the box, and it's the new default.
Let me walk you through it.
Once again processing 11 million rows, now in seconds
Brent continues his optimization journey processing 11 million database events. Starting from 50k events per second, he implements combined inserts, skips unnecessary deserialization, and reaches 400k events per second. A great deep dive into PHP performance optimization.
Read more [stitcher.io]
SQL performance improvements: automatic detection & regression testing
The final part of Oh Dear's series on SQL performance. Mattias introduces phpunit-query-count-assertions, a package that catches N+1 queries, duplicate queries, and missing indexes in your test suite. Since implementing this at Oh Dear, they've eliminated 15% of their SELECT queries.
Read more [ohdear.app]
SQL performance improvements: analysing & fixing the slow queries (part 2)
Mattias delves into optimizing SQL queries using indexes, focusing on MySQL 8.0. He explains how indexes work, how to analyze slow queries using MySQL’s EXPLAIN keyword, and the impact of different index configurations on query performance.
Read more [ohdear.app]
No more down migrations
Database migrations have had a serious refactor in the newest Tempest release
Read more [tempestphp.com]
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]
The Story of Valkey
Valkey is an interesting fork of Redis.
Read more [devdojo.com]
Enabling WAL mode with SQLite in Laravel
– ryangjchandler.co.uk - submitted by Ryan Chandler
SQLite's WAL mode makes using SQLite database much more production-ready.
Read more [ryangjchandler.co.uk]
Using SQLite in production with Laravel
– stancl.substack.com - submitted by Samuel Štancl
Some things to consider when using SQLite in production from the point of view of Laravel apps
Read more [stancl.substack.com]
Why I don't use down migrations original
Every once in a while, someone opens a PR on one of our open source packages adding a down function to the migration. I usually close those PRs fast with a thank you and a message “We don’t use down migrations in our projects”.
While down migrations might seem like a safety net, they're often a false comfort that potentially creates more problems than they solve.
Instead of explaining this in every PR separately, let me share why we don't write down migrations and what we do instead.
SQL Generated Columns and Views: How to Use Them in Your Laravel App
– 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]
Optimize Bulk Insertions with Laravel's New fillAndInsert() Method
Laravel’s new fillAndInsert() method enables bulk insertions while applying model casting, timestamps, and UUID generation.
Read more [www.harrisrafto.eu]
10 Efficient (and Fun) Ways to Seed Your Database
– tighten.com - submitted by Kayla Helmick
This article shares 10 efficient and fun ways to seed your database, from classic PHP arrays to importing CSVs and using AI to generate random, realistic data.
Read more [tighten.com]
SQL NULLs are Weird!
Here are some special cases that you should keep in mind when working with NULL.
Read more [raymondtukpe.com]
SQLite vs. MySQL: What are the differences between MySQL and SQLite?
The choice between the two depends on the specific requirements and use case of the application.
Read more [highperformancesqlite.com]
Laravel’s parallel testing on multiple DB connections
Pretty cool that this behaviour can be customized easily.
Read more [sarahjting.com]
What I Wish Someone Told Me About Postgres
Postgres has many nuances and best practices that are important to understand.
Read more [challahscript.com]
