Recent blog posts
Creating databases and tables for Athena
Ben Welsh and Katlyn Alo have created a course that walks through running your
first Athena query, complete with sample data. I've written about Athena a few
times on this blog and the course works as a great primer. This post will act
as an addendum to the guide, specifically step 4, where you create an Athena
database and table.
A database, in Athena, holds one or more tables, and the table poi
Read more.
NS Dubbeldekker Nieuwe Generatie's design
On 5 March 2025, the Dutch Railways (NS) presented a model of their interior
for the Dubbeldekker Nieuwe Generatie (Double-Decker New Generation), or DDNG
for short. This train will be introduced in 2029 to replace the ageing DDZ and
provide additional capacity to intercity services.
I was going to write an overview of the DDNG and realised the train did not
have an English Wikipedia page yet, so
Read more.
Using S3 Metadata to list recently uploaded objects
Recently, Simon Willison shared how he uses S3 event notifications with Lambda
and DynamoDB to list recently uploaded files from an S3 bucket. The first
thought that occurred to me was to use S3 inventory which provides a daily
catalog of objects within a bucket queriable through Athena. The second idea
involved doing the same with the recently announced S3 metadata feature. Both
methods, I discov
Read more.
Identifying your AWS account when using multiple sessions
Last month, AWS announced multi-session support natively in the AWS console;
previously I'd relied on Firefox containers to separate logins between
accounts. This can be easily enabled from the account drop-down in the top
right of the console.
Multi-session support enabled and the usual account ID and IAM role is visible
in the top right.
Once enabled, this feature supports up to five sessions
Read more.
Recent toots
Recent beer check-ins
Pesky P. is drinking a Stella Artois by Stella Artois at Stadhuis Leuven
View check-in.
Pesky P. is drinking a La Goudale - Blonde à l'Ancienne by Brasserie Goudale - Les Brasseurs de Gayant
View check-in.
Pesky P. is drinking an Ichnusa Non Filtrata by Ichnusa
View check-in.
Pesky P. is drinking a Salted Maple Stout by Totem
View check-in.
Recent Anilist activity
Pesky watched episode 4 - 5 of Kimetsu no Yaiba: Katanakaji no Sato-hen.
View activity.
Pesky watched episode 2 - 3 of Kimetsu no Yaiba: Katanakaji no Sato-hen.
View activity.
Pesky plans to watch Shuumatsu no Valkyrie III
View activity.
Pesky watched episode 1 of Kimetsu no Yaiba: Katanakaji no Sato-hen.
View activity.
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