One of my projects that runs 24x7x365 is a web scraper. I’ve iterated on the approach several times, and what is currently working is to do the fetch and then save the entire HTTP response in a Postgres database. From various other projects, I can then query one central database and extract out data that … Read more
When your server is down, it’s stressful. I’ve just recovered from an issue with WordPress where the PHP container was crippling my server because – for reasons I cannot explain – connectivity to the database had just died. This actually happened to me on another server a few months ago, and I wasn’t that bothered … Read more
In this post, we’re continuing with our Spring Boot guestbook example, but this time we’ll be adding persistence by integrating a PostgreSQL database. While the overall process is fairly straightforward and well-documented, there were a few things that caught me off guard along the way. One challenge I faced was integrating Spring Data repositories with … Read more
Today I needed access to an environment variable whilst building a Docker image from a Dockerfile. To make the example concrete, I wanted to get access to the Git commit hash exposed in a CircleCI build. The idea was to then use this commit hash inside my build as a cache buster on client side … Read more
Yesterday I got hit with the double whammy. I tried to upgrade GitLab to v16.3.4 as part of their recent critical security release when I realised that the GitLab server was running version 15.x (I don’t remember which minor release), so first I would need to install 16.0.0, then get up to 16.3.4. This, it … Read more
This one cost me a whole bunch of time. Annoyingly I got a Docker version of Postgres 16 working on one machine, but a couple of days later I needed to update another and I hit this error: Somewhat fortunately for me, this time around, was that this was a test setup I have used … 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
I suspect this problem won’t impact too many people. However, it caught me out so I figured I’d document it and share the fix. Heads up: you’re probably missing a next.config.js file. Or perhaps you have one, but it’s not got the right setting. OK, I will first share my config: That’s my Dockerfile in … Read more
Today I hit on an issue whereby I tried to bring up a new Docker project, using a named network, and hit the following error: Which isn’t the most helpful thing in flagging that I had hit the default maximum number of networks that a Docker host can have active. There’s a potential quick fix … Read more
Today I needed to reset a user’s password on a WordPress blog which uses MySQL as its backing database. The WordPress blog, the MySQL database, and the NGINX server are all running on the remote server via Docker. More specifically they use a docker-compose.yaml file. How this docker-compose.yaml file looks is not super important, but … Read more