database

All my posts about database.

laravel php performance mysql optimization

Laravel Site Search v3 is here: crawl and search your entire site using just your database original

Mar 12th 2026 by Freek Van der Herten – 5 minute read

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

Jan 30th 2026 – stitcher.io

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.

SQL performance improvements: automatic detection & regression testing

Jan 28th 2026 – ohdear.app

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.

SQL performance improvements: analysing & fixing the slow queries (part 2)

Oct 6th 2025 – ohdear.app

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.

No more down migrations

Sep 19th 2025 – tempestphp.com

Database migrations have had a serious refactor in the newest Tempest release

SQL performance improvements: finding the right queries to fix

Sep 16th 2025 – ohdear.app

At Oh Dear, my colleague Mattias recently vastly increased the performance of our service. Here's how he did it.

The Story of Valkey

Aug 25th 2025 – devdojo.com

Valkey is an interesting fork of Redis.

Enabling WAL mode with SQLite in Laravel

Aug 12th 2025 – ryangjchandler.co.uk - submitted by Ryan Chandler

SQLite's WAL mode makes using SQLite database much more production-ready.

Using SQLite in production with Laravel

Aug 11th 2025 – stancl.substack.com - submitted by Samuel Štancl

Some things to consider when using SQLite in production from the point of view of Laravel apps

Why I don't use down migrations original

Aug 1st 2025 by Freek Van der Herten – 3 minute read

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

Jul 29th 2025 – 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.

Optimize Bulk Insertions with Laravel's New fillAndInsert() Method

Apr 24th 2025 – www.harrisrafto.eu

Laravel’s new fillAndInsert() method enables bulk insertions while applying model casting, timestamps, and UUID generation.

10 Efficient (and Fun) Ways to Seed Your Database

Mar 19th 2025 – 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.