Serverless WordPress
WordPress’s editor without a WordPress server. The editor runs in your browser with WordPress Playground, and Cloudflare stores the content and rebuilds the static site.
Projects
Turnstile protected static forms
Spam-protected website forms without a form service. A Cloudflare Worker checks Cloudflare Turnstile and emails each submission, and Vue composables handle the form.
TV Shows Tracker
A web app that tracks the TV shows I watch, emails me when a show is renewed or cancelled, and adds new episodes to my calendar. I first built it in 2020, then rebuilt it with Nuxt on Cloudflare.
GitHub Contributions
View my profile on GitHub.
Blog
How AI helped me add my Mitsubishi Delica D:5 to UK insurance databases
Earlier this year I bought a 2007 Mitsubishi Delica D:5. The D:5 has been sold in Japan since 2007 but was never officially sold in the UK. Mine is a Japanese import, which means that while it is perfectly legal and registered with the DVLA, getting insurance for it can be a little more complicated […]
Moving my site from Netlify to Cloudflare Workers
I moved this site’s builds, hosting, forms and images from Netlify to Cloudflare Workers, and upgraded it to Nuxt 4 and TypeScript along the way. Here’s what moved where, and what caught me out.
Replacing a BI tool that couldn’t handle 40 million rows
Our reporting went from stale database syncs, to MySQL views, to a BI tool that copied everything and choked on our biggest table. Querying the database directly with Grafana cut dashboard updates from two hours to near-instant.
Scaling ECS on PHP-FPM workers instead of CPU and memory
Our ECS services scaled on CPU and memory, which meant traffic spikes took the platform down before a new container ever started. Scaling on busy PHP-FPM workers fixed the outages and let us run 3 containers instead of 8.
Running our PHPUnit suite on one EC2 runner instead of 40 GitHub runners
Our PHPUnit suite was split across a 40-job matrix of GitHub-hosted runners. Moving it onto a single self-hosted EC2 runner simplified the pipeline and saves us over $200 a month.
How to download a Google Sheet on a cron
Working with Google Cloud can be confusing for beginners and sometimes all you need is to manipulate a Google Sheet. I have a couple of use cases for downloading a sheet and uploading a sheet. I haven’t quite figured out the upload part yet, but I have got downloading to work. I’ve decided to write […]