The Hidden Blog

As it turns out, I do have a hostname.

2024 Lock Contention on Google Cloud SQL and Postgres

I recently looked into some performance issues on a large PostgreSQL 13.12 instance. One part of that was to make sure we don’t have too much locking going on in busy tables.

Locking metrics on the Cloud SQL dashboard

Locking metrics on the Cloud SQL dashboard...

Read the post

2023 Two months in Hong Kong

In 2023 I spent two months in Hong Kong, here’s a small subset of places that I remember and liked. More inspiration for places to visit are in my vlog episodes I shared in a previous post. There’s a lot of things missing but half the fun is finding places yourself anyway.

Essentials

Read the post

2023 Vlogging

This year I started playing around with creating video content. The goal was to create low-effort semi-frequent video summaries of what I have been up to. I didn’t want to do narration or anything else that would raise the barrier of publishing a video.

All videos are available on my YouTube channel...

Read the post

2023 Taking a look at Nostr

After hearing about Nostr from multiple people over the past weeks I decided to take a look and learn more about it. I found nostr-resources.com, usenostr.org and github.com/aljazceru/awesome-nostr to be helpful to get an initial overview.

Running a nostr relay

As a next step I looked into setting...

Read the post

2023 Fixing failed installation of EPSON printer driver

Recently I ran into the issue where installing an EPSON SC-P900 printer driver on macOS (before and after the update to Ventura) always failed with a generic “Installation failed” message.

I started my investigation by looking at the installation log with the following command while...

Read the post

2022 Convert video for Twitter

If you want to post a video on Twitter there’s a few rules that are important for the video to be accepted.

Unfortunately the interface will only show “The video file is not compatible” while only the actual API request in the background will tell you exactly what is wrong. If you...

Read the post

2022 Push notifications from AppSignal with Pushover

I’m using AppSignal to monitor Birdfeeder. Birdfeeder’s job is to send your Twitter bookmarks to your email inbox so you don’t forget about them.

On the technical side it’s a Rails app which relies on Sidekiq to process background jobs. Bookmarks have to be fetched, accounts...

Read the post

2022 Building container images in Kubernetes with kaniko

A few weeks ago I rebuilt a GitLab CI pipeline at JustWatch. One part of that was to move the step building the container images in the Kubernetes cluster from artificer to kaniko.

I wrote up a short guide on the JustWatch blog in case you are curious.

2022 Listening to a movie as an audiobook

Today I was reading a comment on HN that piqued my interest.

I used to rip the audio of my favourite movies and listen to them like audiobooks. Because I was usually familiar with the visual parts, I could enjoy the dialogue and the music in a different way.

This sounded like a simple enough task...

Read the post

2022 Migrating from self-hosted Postgres to DigitalOcean

Until now Birdfeeder was powered by a self-hosted Postgres instance which is used by various other side projects. It was running out of space and decided to migrate to a managed Postgres instance on DigitalOcean (Affiliate link, giving you $100 in credits).

The reason for going managed was that I...

Read the post