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

Working with dates in SQLite and Grafana SQLite can be used as a data source for Grafana using a community plugin maintained by fr-ser. Out of the box the plugin has support for time formatted columns, which work on visuals like time series, and time range macros, which use the dashboards datetime picker. This post has a few of my notes. Unix epoch numbers (e.g. `1773149763`) and RFC3339 strings (e.g. `2026-03-10T15:36:03+01:00`) work n Read more.
Access S3 Tables with QuickSight I've been exploring AWS analytics services again so it's time for another TIL. This post goes over accessing and querying S3 tables from QuickSight, via Athena, as S3 tables don't natively work with QuickSight. Here's the TL;DR on what you need to do: 1. Create your S3 Tables bucket, namespace and table. 2. Ensure that your S3 Tables bucket has AWS analytics service integration enabled. 3. Read more.
In Praise of --no-dry-run There are scripts that are designed only be run a handful of times, or maybe even once under rare circumstances. They are usually tested a lot of more times than they are intended to be executed, or when they are executed, their actions could be detrimental, this is where `--no-dry-run` option comes in. In my career, I seem to have worked on a lot of system, or application migrations. I'm not sur Read more.
EdTech gets confusing. Micah Blachman, a seventh-grader, candidly writes about the educational technology used at his school. Reading his insights brought back some memories of when technology like this was first introduced at my school. Now it's been a while, almost two decades, actually, but I remember thinking surely things would get better in the future. It does not. I wanted to add some commentary from my dated pe Read more.

Recent toots

Recently, I switched from a Windows laptop with WSL to Mac at work and I'm slowly realizing the things I took for granted. To start, the `watch` command. Luckily brew has a package that helps. https://blog.x-way.org/Mac/2024/11/02/Missing-watch-command-on-macOS.html Read more.
@niccokunzmann Absolutely! I'd definitely like to give it a go. I just took a look at version 7.x and like the move towards guiding the user towards creating valid calendars with the new class methods. Where in the documentation would the tutorials live? Would it be a precursor to the How-to's and Reference Guide? If you already have it described in an issue I'd be happy to take a look. Time to Read more.
@coreice InterCity rolling stock at Weesp today? Read more.
Recently took over a project that was filled with TODOs so it was time to install snitch. https://github.com/tsoding/snitch Read more.
TIL it's Tampermonkey not Tapermonkey. I've been saying it wrong for years. Read more.

Recent beer check-ins

Pesky P. is drinking a San Miguel Premium Especial (5.4%) by Grupo Mahou-San Miguel View check-in.
Pesky P. is drinking a Cosmic Blond by Uiltje Brewing Company View check-in.
Pesky P. is drinking an IPA by Honest Greens at Honest Greens View check-in.
Pesky P. is drinking a NIJPA by Brouwerij 't IJ View check-in.

Recent Anilist activity

Pesky watched episode 8 of Golden Kamuy: Saishuushou. View activity.
Pesky watched episode 7 of Golden Kamuy: Saishuushou. View activity.
Pesky watched episode 5 - 6 of Sousou no Frieren 2nd Season. View activity.
Pesky watched episode 6 of Golden Kamuy: Saishuushou. View activity.