No release, weekly updates, and weekly tip

No release

No release this week as Taylor is on vacation.

Weekly Journal

A few Human Shifts came in last week. One I'm finishing up by adding a test suite and CI. The other will be upgrading a rather large application from Laravel 5.7.

Of course while doing these, I'm dogfooding Shift making tweaks along the way. Mostly clarifying comments and small updates for the absolute latest version of Laravel 12.

Otherwise, I'm in video editing mode. I'll share more about the course in the coming weeks. I'm also shipping printed copies of BaseCode. There are actually 3 copies left. So last chance if you want one of the 50 ever printed.

Weekly Tip

In my livestream this week I jumped on the Laravel Nightwatch hype train. And let me say, the hype is real.

After I thought I destroyed my production database, Nightwatch actually found some slow pages. This led me to some slow queries. They were just under the MySQL slow query log threshold. So I hadn't caught them. In addition, the query was on columns I thought had an index, but actually didn't.

Adding the proper indexes dropped the queries from an average of 500ms to 6ms. Basically a 100x improvement.

It took about 10 minutes to set up Nightwatch and capture the slow queries. Then a 2 line migration up to add the indexes. Time well spent!