Whilst shutting down some old projects, I’m archiving all of their folders and storing them in S3 in case of an emergency. I don’t have AWS credentials stored and set up on the EC2 instance, so I’m passing them through as variables to the script below. As with the script to export tens of thousands of individual MySQL databases, you’ll want to edit the values at the top. EFS_MOUNT_POINT is the full path to where the EFS drive is mounted S3_BUCKET is your target S3 bucket AWS_… self explanatory!

I’m a big fan of single-tenant databases, one for each customer. With MySQL and InnoDB, a single server can scale to tens of thousands of individual databases. As long as you’re deliberate with your schema design up front - here, I’m a big fan of explicit key/value tables that let you assign arbitrary metadata to objects that are more normalised - you buy yourself incredibly simple isolation by simply selecting the appropriate database once you’ve identified your tenant (using PHP’s select_db()).

I’ve just completed my first tiny product DoubleShot, a quick and easy way to create and share ‘before’ and ‘after’ photos to social media. The final piece was to get payments working so that people could buy the app and get access. It seems that the favoured way to do this is with Laravel Cashier - have the customer create an account first, then subscribe that User model to a subscription plan.

While working on Ghostmail, an Electron-based Maildir frontend I’ve built, I had to get the app ready for distribution on other people’s machines by code signing and notarising it. I’m using Electron Forge to build the app, and I expected everything to work pretty much out of the box. However, I ran into an important, niche issue that should be highlighted. I added the dotenv package to my development dependencies, initialised it at the top, and filled out my .

Shortly after posting my initial version to run Laravel queues with Supervisor on Coolify, I realised that I should also get supervisor to run and control nginx and php-fpm as well. So here’s an updated version of the Nixpacks script to handle this. The revised PHP provider As before, I’ve added a nixpacks.toml file to my project root, which gets picked up by Nixpacks and lets you extend the default PHP provider.