Lightnews — Scholar-powered news

Tomorrow, I’ll be giving two talks at the ForumPHP conference in Paris 🇫🇷
event.afup.org/forum-php-20...

In the first talk I’ll be showcasing our multi-tenancy package (spatie.be/docs/laravel...), and in the second I’ll demo a few over our smaller packages.

See you there! !

Programme – Forum PHP 2025 – Cycles de conférences AFUP

Découvrez le programme du Forum PHP 2025, l'édition des anniversaires

event.afup.org

1 6

Freek Van der Herten @freek.bsky.social · 8d

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

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.

ohdear.app

6

Reposted by Freek Van der Herten

Shawn Hooper @shawnhooper.ca · 11d

Discovered the Presets feature in v3 of Spatie's Laravel CSP package this week. What a powerful improvement.

Blogged about it here:

shawnhooper.ca/2025/10/03/c...

Thanks @spatie.be !

shawnhooper.ca

1 2

Freek Van der Herten @freek.bsky.social · 12d

🔗 Http::batch with hooks in Laravel 12.32

Http::batch with hooks in Laravel 12.32

Laravel 12.32 introduces Http::batch, a clean way to send concurrent HTTP requests with lifecycle hooks for progress, success, failure, and finalization.

nabilhassen.com

3

Freek Van der Herten @freek.bsky.social · 13d

🔗 Things I wish I knew when I started programming

Things I wish I knew when I started programming

Brent Roose has written an excellent book. This time on his programming journey and the lessons learned along the way. It's not too long, I personally read it in one sitting, and liked it very much.

things-i-wish-i-knew.com

2

Freek Van der Herten @freek.bsky.social · 19d

I’ve just sent my newsletter on #PHP, #Laravel and all things web

You can read it + subscribe here:

freek-dev.mailcoach.app/archive/2f60...

1 1 8

Freek Van der Herten @freek.bsky.social · 20d

🔗 npm ci vs npm install

npm ci vs npm install

A quick guide to the differences between `npm ci` and `npm install`.

ryangjchandler.co.uk

2

Freek Van der Herten @freek.bsky.social · 21d

🔗 Laravel Notifications: dynamic channels, priority, and delayed sending

Laravel Notifications: dynamic channels, priority, and delayed sending

Laravel Notifications are one of my favourite parts of the framework.

crnkovic.me

2

Freek Van der Herten @freek.bsky.social · 22d

Very cool! Will you open source this? 🙏

1 1

Freek Van der Herten @freek.bsky.social · 22d

I’ve also open-sourced it, you’ll find the code in this repo: github.com/ohdearapp/re...

Blogpost on why it was created (spoiler: for our own testing needs): ohdear.app/news-and-upd...

GitHub - ohdearapp/request-mirror.ohdear.app: The source code of request-mirror.ohdear.app

The source code of request-mirror.ohdear.app. Contribute to ohdearapp/request-mirror.ohdear.app development by creating an account on GitHub.

github.com

Freek Van der Herten @freek.bsky.social · 22d

I’ve deployed a simple micro-service called Request Mirror
request-mirror.ohdear.app

Send a request, and Request Mirror will respond instantly with JSON containing all properties of the original request. Perfect for API development, webhook testing, and learning HTTP.

Request Mirror - HTTP Testing Service by Oh Dear

The simple HTTP request testing tool. Send a request and get instant JSON response with all request details. Perfect for API development, webhook testing, and learning HTTP. Free service by Oh Dear.

request-mirror.ohdear.app

1 2

Freek Van der Herten @freek.bsky.social · 22d

🔗 PSR-20 Clocks: Testable Time in PHP

PSR-20 Clocks: Testable Time in PHP

Learn how a ClockInterface helps you decouple time and write stable, testable code. It's about time!

doeken.org

2 7

Freek Van der Herten @freek.bsky.social · 25d

🔥 One of our users used Flare's MCP server to analyse all the performance data Flare collects and to give an optimization report. Very very cool!

(I have Peter’s permission to share his message all of you 👍)

flareapp.io/docs/flare/g...

1 5

Freek Van der Herten @freek.bsky.social · 25d

🔗 No more down migrations

No more down migrations

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

tempestphp.com

4

Reposted by Freek Van der Herten

Brent @brendt.bsky.social · 27d

I just love Tempest's simplicity! 🌊

I'm finally converting aggregate to Tempest, and I'm migrating data between two databases, super easy 🤩

2 7

Freek Van der Herten @freek.bsky.social · 27d

In the next few days. Still needs to be written 🙂

1

Freek Van der Herten @freek.bsky.social · 27d

🚀 I just deployed Oh Dear’s (ohdear.app) MCP server.

Here are a couple of example prompts:
“Analyse the performance of spatie.be”
“Show me the trends of the lighthouse reports”
“Which DNS records changed recently”

📚 Here are the docs: https://ohdear.app/docs/integrations/oh-dear-mcp-server

4

Freek Van der Herten @freek.bsky.social · 28d

At Oh Dear, my colleague Mattias recently vastly increased the performance of our service. Here's how he did it: ohdear.app/news-and-upd...

SQL performance improvements: finding the right queries to fix (part 1)

This post covers tips and tricks for performance tweaking your SQL queries by first identifying which queries need work.

ohdear.app

2 2 11

Freek Van der Herten @freek.bsky.social · 28d

Did you know we came up with the name “Oh Dear” (ohdear.app) in a bar? We saw an ad for “Moeder Overste” depicting a head nun, and thinking what she would say if her website was down.

We now use that story as a basis of a new marketing campaign where we send that beer to potential new users.