Pesky's home

Welcome! This website serves as the home base to all the content I publish, which includes posts I write, videos I upload and more. The content generally surrounds trips I go on with family, trains and technology.

Here are some other places you can find me:

Blog Mastodon YouTube Email

Recent blog posts

Saying goodbye to bicycle gutters? I was not expecting a large amount of press coverage on bicycle gutters at train stations, but it makes sense given that this is the Netherlands. ProRail, in a weird move, based on their internal investigation and reports, has a new policy where no bicycle gutters will be installed at staircases in new or renovated stations. These gutters are channels at the side of staircases designed to fit bicy Read more.
Query Glue tables across accounts and regions Recently, I updated a Stack Overflow answer to include some information on Lake Formation that was new to me: _resource links_. The answer also covered a few other methods to query data cataloged in Glue across accounts and regions. Here's the setup: you have a Glue Data Catalog and a S3 bucket in an AWS account called _Owner Account_ , and there are users in different AWS accounts and regions tha Read more.
Creating a degraded ZFS pool TL;DR: There may come a time when you need to build a ZFS pool in a temporarily degraded state. Reddit user u/mercenary_sysadmin describes how this is done, and this post provides additional commentary. The approach uses a temporary file in place of the disk, then taking it offline resulting in a degraded pool. When the physical disk is available, the file can be replaced with the actual disk in Read more.
First impressions of Excalidraw A few weeks ago, I stumbled upon Excalidraw, which is a whiteboarding/diagramming tool that has a certain _aesthetic_. I liked the design of the diagrams I saw, so I decided to give it a try. Coming from drawio, I was immediately impressed with how intuitive it felt. After playing around with Excalidraw for an hour, I decided it was worth actually using for work, and so I hosted it locally on my m Read more.

Recent toots

Over the years I've gone through a few coffee presses, they all seem to last a year or so before the glass container breaks. Maybe I'm too rough on them or just unlucky. Instead of buying a new one I decided to buy and try the AeroPress for the first time, no regrets. My morning coffee has been upgraded. Read more.
While messing around with h3 I decided to use it to plot all the Albert Heijn supermarket locations in the Netherlands. From OpenStreetMap I was able to extract 897 supermarket locations. Each cell is roughly 36km^2 with the most dense cell in Amsterdam at 32 stores. #map Read more.
@smveerman Reminds me of this instructional video on getting your bicycle up and down an escalator. https://indebuurt.nl/zoetermeer/nieuws/opmerkelijk/typisch-zoetermeer-zo-ga- je-met-fiets-de-roltrap-van-de-mandelabrug-op-en-af~85136/ Read more.

Recent beer check-ins

Pesky P. is drinking a Brutus by Brutus The Beer at Green&burger by Biocenter View check-in.
Pesky P. is drinking a Pilsner by Gulpener Bierbrouwerij View check-in.
Pesky P. is drinking a Pilsner Urquell by Plzeňský Prazdroj View check-in.
Pesky P. is drinking an Amstel by Amstel Bier View check-in.

Recent Anilist activity

Pesky watched episode 11 of Lazarus. View activity.
Pesky watched episode 8 - 10 of Lazarus. View activity.
Pesky watched episode 7 of Lazarus. View activity.
Pesky watched episode 1 - 6 of Lazarus. View activity.