Transfering a Smart Card to Apple Wallet

December 21, 2025 | Comment

On a recent trip to Washington DC we discovered the Metro’s smartcard “SmarTrip” which can be used to tap-in and tap-out at stations and on buses too. This was pretty convenient, but it meant yet another plastic card to carry around and potentially lose.

However, there were signs up saying that it was possible to transfer the balance from a physical card to your Apple Wallet (or Google equivalent if you were that way inclined). The instructions were simple enough:

To transfer your SmarTrip card to Apple Wallet, open the Wallet app on your iPhone, tap the “+”

… Read the rest

Storing Data in a PHP Project

October 15, 2025 | Comment

Over the last year I have been reevaluating how and were I store the data for my projects. Traditionally I have added a new database in MySQL for each but I thought that was a bit overkill for some of the smaller, single user, projects that I was working on.

There are several options for storing your data, but each comes with its own trade-offs in setup time, performance, and scalability. Here I look at the ones I have used in my prejects — flat files, SQLite, and MySQL — and see where each one shines (and where … Read the rest

Payment Security, Greek Style

October 8, 2025 | Comment

Handheld chip and pin machines aren’t as universal as I thought they were. On a recent trip to the States, I found that it is still much more likely that they will take your card away to some dark corner to produce you a paper receipt, no doubt cloning it in the meantime!

In the UK that almost never happens but the vast majority of restaurants will come to the table with a machine these days, demanding payment before you’ve even seen this bill!

While holidaying in Greece earlier this year I found in a number of places where not … Read the rest

What’s the Difference Between Matter and Thread?

July 27, 2025 | 1 comment

I’ve recently been getting into home automation and Home Assistant in particular (expect more posts on that as I get my head around it).

Words that frequently come up when dealing with home automation devices are Zigbee, Thread and Matter. I was familiar with Zigbee but was confused about Thread and Matter and how they worked together so I asked my friend ChatGPT to explain. I found it useful so decided to tidy it up and post it here.

What are Thread and Matter?

Thread and Matter are two of the latest smart home standards, often mentioned together, … Read the rest

Customer Support BS

June 18, 2025 | Comment

If you contact customer support, literally any customer support, with any technical issue, depending on your device, you are likely to be met with one of the following responses:

Turn it off and on again (any piece of hardware)
Clear your browser cache (any web app/site)
Delete and reinstall it (any mobile app)

In their defence, those in customer support would say that this solves 90% of issues, but it is annoying that these are the first things offered up, and they’re not happy if you tell them that you’ve already done them.

Of course, many more issues could be … Read the rest

Ella, The Robot Barista

June 4, 2025 | Comment

On a recent trip to Keukenhof, the Netherlands, I was struck by the crowd gathered around a windowed box. I had sort of assumed that it contained some rare plant, given where we were, but in fact, it was Ella, the Robot Barista. Ella is, apparently, able to “brew more than 300 coffee combinations at 200 cups per hour” using data, Robotics and, of course, AI.

Here she is in action:

… Read the rest

COLMi Smart Ring – an Update

April 9, 2025 | Comment

Not so long ago, last January in fact, I wrote about the COLMi Smart Ring, the smart ring that you can pick up on Aliexpress for about fifteen pounds. In my conclusion I wrote that “I like the design of the ring, but the quality of the finish shows where cost savings have been made to keep the price down.” Now, less than three months later, I am back as that has proved to be highly accurate.

The picture above shows my R06 smart ring after three months of use, and below it an unworn one. As you … Read the rest

Moving a WordPress Install to a New Domain

March 26, 2025 | Comment

Over the years in both my professional and personal lives I have had to move WordPress sites to new homes that required changing the domains. This has led me to develop a set of instructions that I use successfully every time I migrate.

The first warning I should give is that what follows is not the only things you have to do but it is a decent starting point.

Updating the Database

The second warning is that here be dragons. The following requires making direct changes to the WordPress database which could lead to your site no longer working. … Read the rest

RWOL from Alexa

February 10, 2025 | Comment

At the end of 2023, I wrote about how I had used a Raspberry Pi Zero to act as a machine to remotely turn on and off a media server that I had in my house. The idea being that it was unnecessary to have it on 24/7, consuming electricity when I was asleep for much of that time.

While I had a nice little web app from which I could trigger the start up and shut down I always wanted to be able to do it using voice commands via Alexa. Today I finally got round to doing that … Read the rest

jolpica2ergast F1 Database Updater

January 2, 2025 | 1 comment

In addition to this blog and my personal blog I also maintain a Williams Racing fan site at https://williamsdb.com. In fact, this is my longest running site having first gone live on 6th May 1996. As you can imagine this has gone through a number of itterations over the years and the latest makes extensive use of a results database called Ergast.

And then it was gone

About a year ago the maintainer of Ergast announced that he was going to discontinue updating it at the end of 2024. To be honest, I don’t blame him as it … Read the rest