Discogs Wrapped

If you’re not a Spotify user, as I’m not, then all the self-congratulatory Spotify Wrapped posts at the end of each year can become quite wearing. It’s not that I don’t listen to music; it’s just that I don’t consume it through streaming. I’m an old-fashioned, physical music kind of guy, and I have lots of vinyl records.

What I thought if I could have my own version of Spotify Wrapped? Enter…

Discogs Wrapped

My music media collection is all catalogued in the online service Discogs which also has an api. In fact, it was this that I used this … Read the rest

jolpica2ergast F1 Database Updater

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

Where’s Santa?

I had an unusual request from my friend John recently – could I help him map the location of Santa as he goes about his deliveries? Ok, it wasn’t quite like that. He is a member of the Lions, and every December they take out a sleigh with Santa on the back through the streets to the delight of lots of excitable children. The issue was that parents didn’t know exactly when he was going to appear in their streets and were constantly looking and waiting for his arrival. If there was a map of the live position, this would … Read the rest

When Did I Last? (WDiL) – Version 4

It’s been a while since I last pushed a new version of WDiL but finally I got round to adding the few things left that I wanted in the app – most notably notifications. Read on for details of that and everything else that’s included.

New Functionality

Let’s take a look at what has been included in this latest release:

  • the interval between triggers is now shown on the trigger stats page
  • added a user account page to allow setting of Pushover details
  • send reminders notifications via email and Pushover
  • fixed some bugs.

Notifications

One of the things I felt … Read the rest

When Did I Last? (WDiL) – Version 3

I’ve pushed another update to WDiL adding lots of new functionality and bug fixes. The most impactful of these is the forgotten password routine as this now requires the addition of the ever reliable PHPMailer. However, the most useful and visible are the changes on the activity stats page which now includes more statistics and a graph showing trends.

New Functionality

Let’s take a look at what has been included in this latest release:

  • graph of triggers and intervals on stats page
  • details of the general interval trend on stats page
  • you can add a comment to a trigger
Read the rest

When Did I Last? (WDiL) – Version 2

When I launched WDiL earlier this week I knew that it was what might be politely described as a MVP. And while I like SimpleCSS it doesn’t make for the most attractive sites. Therefore, I set about making it more appealing while also adding more functionality.

Moving from Simple CSS

I spent quite a bit of time looking for a pre-built theme that I could use as the basis of WDiL but none seemed to be where I wanted to go. In the end, I plumped for vanilla Bootstrap which with its pre-built components allowed me to get a … Read the rest

When Did I Last? (WDiL)

My electric toothbrush seems to be running out of charge quicker and quicker but is it or am I just misremembering when I last charged it? This is the first world challenge that I set about to change with WDiL!

Introducing When Did I Last? (WDiL)

WDiL aims to help solve those sorts of problems by allowing you to record every time you do something and then see stats on things such as frequency and average interval.

While I have tried to make it very simple it still requires a bit of setup and hosting by you. As part of … Read the rest

Computer Education in Schools Instruction Language (CESIL)

When I first learned programming in about 1978 the school I attended was lucky to have a Research Machines 380Z on which there was the BASIC language. Using this one of the pupils then wrote a CESIL interpreter for their (I guess) O Level project. Other pupils then used this to learn the fundamentals of programming.

Skip forward a few years and I now owned a Sinclair ZX Spectrum having also previously had a ZX81 too. I decided that I would also write a CESIL interpreter this time using Sinclair’s variant of BASIC. Remarkably I still own the sheets of … Read the rest

Overcast Statistics

Podcasts are huge at the moment and they are pretty much all I listen to these days when I am out walking or in the car. I do this by the (mainly) excellent Overcast app. I say mainly because it has a UI that I struggle to find things in. Anywho, the one thing that it lacks (other than an intuitive UI) are decent stats and I really wanted that for my annual Review of the Year posts over on my personal blog.

After a quick DuckDuckGo I found the following post from James Hodgkinson with a Python … Read the rest

Posting to Bluesky via the API from PHP – Part Five – Putting it all Together

NOTE: This post is mainly about how I developed the php2Bluesky library. If you are looking for information on using the library in your own code please see here: https://github.com/williamsdb/php2Bluesky/

In this series of posts we have looked at:

In this final post we are looking at putting it all together. This includes a worked example plus a complete library of functions that will allow you to easily interact with the Bluesky API.

The Prerequisites

What this project has predominately been about is the correct formatting … Read the rest