Development

Laravel Pulse now supports `use_upsert_alias`

We hit a bit of a bug in a couple of our Shopify Apps this week. We use Laravel Pulse and realised that for a couple of them, the dashboard was completely empty. This meant that we weren't getting alerts for issues including stuck jobs and other things we have configured.

I eventually tracked this down to a change I'd made earlier in the year, to support MySQL 8.4. This version of MySQL deprecates using VALUES in an upsert query. A PR was merged into the framework several years ago which added the ability to use the alias instead of VALUES by setting use_upsert_alias to true inside your database.php config file.

Turns out, Laravel Pulse didn't work with that set to true and when running the ingest, our 2 apps that do use the alias were erroring with

[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'value' in field list is ambiguous

So, I put together a PR which updates a bunch of queries, only when use_upsert_alias is set to true. Taylor merged it and hopefully it will get released soon!

💡

13th June 2026: I've just noticed that this fix was released as part of v1.7.4, so make sure you're apps are using that version!

Using Cursor Security Agent

Last month, we received a report from a security researcher via our helpdesk that one of our apps was susceptible to XSS attacks. The report was on a weekend, but given the urgent nature (and the fact I wasn't doing much), I got to work on fixing it.

Laravel Moat

I've been on a bit of a security drive recently, what with all of the recent supply chain attacks happening in the NPM and Composer worlds. Laravel recently unveiled a new package called Moat, which reviews the security of your GitHub organisations and repositories. Whilst controls for these

PCOV for code coverage

In Some ways of speeding up your tests I mentioned about using PCOV as an alternate for Xdebug for code coverage. Xdebug is fantastic, but it can be quite slow, which means when you're running your tests in a CI/CD environment, your pipelines can start to get

Using PHP Enums for Laravel Shopify

I recently announced that I've became a maintainer for the Laravel Shopify package: I’m now a maintainer for Laravel ShopifyI’m excited to announce that I’m now a maintainer for the Laravel Shopify package. This is a package that I’m using heavily at work so

Read more

Using Cursor Security Agent

Laravel Moat

PCOV for code coverage

Using PHP Enums for Laravel Shopify