Chris 
A very specific issue today, but one that I found quite a nice solution for – albeit with the need to install some extra things. The issue I faced was that I have a large number of directories, each containing 10-15 images. For each directory I needed the file name, and image dimensions for every … Read more
Here’s the problem we are addressing today: you have a set of numerical data returned by your Postgres query. Your numbers look alright, but some very high (or very low) values seem to be throwing things out of whack. What you’d like to do is eliminate the outlying values from your result set, and keep … Read more
This is a post aimed at absolute beginners to Kotlin Spring Boot projects, who maybe have joined an existing team / project that uses this setup, and are unsure how best to set up their local environment using the application.properties resources. Or, to put it another way, I joined a project that is using Spring … Read more
Bit of an odd one today. I was browsing around a production system (my own, thank you), and tracing my way through some Postgres routines trying to track down why a query seemed to be returning an unexpected / outdated result. When I opened one of the routines I was met with this: The real … Read more
I’m no Spring Boot expert. Far from it. However, in the project I am working on at the moment, there is a Spring Boot API created using Kotlin that I need to support. Part of that challenge is just getting the API up and running. I’ve had a few days of head scratching with this … Read more
Today I needed a query that could take some nested JSON data, a column ID, and then create a single row for each of these distinct column ID’s to show some summary numbers of different nested JSON values. I’ve horribly explained that, and so you can imagine just how much fun I had writing the … Read more
Whilst updating an older Express project to use TypeScript, I came across a file where I was pulling in a JSON file directly using require. I wanted to remove the require usage and switch to import, but this was not quite as straightforward as I initially expected. It turns out that this can be demonstrated … Read more
Here’s the requirement: you want to work on your Linux (Ubuntu, in my case) desktop, but your data lives on an OSX / Mac machine. You need to share your folder from Mac, and connect to it from Linux. How do you do that? Well, there is likely more than one way to do this. … Read more
I’ve come across the select case syntax in Postgres before, but never had to figure out what it does. However on my current project I was faced with a query where I had to understand it, so I went about setting up a little local demo file to figure out how to use case in … Read more
In this post we will cover how to use the Linux command line to create a new file in each sub directory, only if that file doesn’t exist. Of course this can be done by hand, but we are all lazy people, right? So why not make the computer earn its keep? Essentially then, quite … Read more