I’ve recently had to shut down some old platforms. This presented an interesting challenge, as I had some requirements: No ongoing server costs/maintenance Custom error messages depending on the domain, so the solution can be applied to multiple legacy platforms Work across wildcard subdomains, which are used to identify the tenant I already manage DNS through Cloudflare, and after investigating their Workers a little bit, I found that they provide the perfect solution.

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 .