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 my wife and I go on, trains and technology.

Here are some other places you can find me:

Blog Mastodon Twitter YouTube

Recent blog posts

Import a CSV file into SQLite ## sqlite3 CLI Using the sqlite3 CLI allows you to import CSV files into a new or existing database file. The following multi-line command will import the CSV file, `disruptions.csv` into the `disruptions` table. All columns will be of type TEXT if created by the import command. sqlite3 data.db <Read more.
Bad week for the Dutch Railway The Dutch Railway, NS, has not been having a good week, in fact, this Monday NS reported the lowest punctuality score this year with 72.3% of passengers arriving to their destination with less than a five-minute delay, the average is around 90%. This week has been difficult due to several different factors. There were a few very unfortunate incidents between trains and passengers on the track on M Read more.
Fetching RSS feeds from YouTube It's an open secret that you can follow YouTube channels through RSS, it's also something I've covered on this blog before. What I wasn't aware of until recently was how difficult it could be to find the RSS feed for a YouTube channel. I mistakenly thought any RSS service could discover the feed URL from a YouTube channel, but after chatting with Andreas (82Mhz) on Mastodon we discovered this wasn Read more.
The NS International app could be better In my last post, I praised the NS International app, while it's user-friendly and frankly better than some of the other apps or websites I've used there is still room for improvement. I'll use a recent trip to Leuven from the Netherlands as an example. The roughly 3-hour trip was booked over a month in advance and I was able to get a cheaper price through the Early Bird discount. Unlike the usual Read more.

Recent toots

@mattgrayyes I've been loosely following Gov.uk's blog this year on their development of the chat bot. They completed some internal "red teaming" earlier this year and later started private betas. I think their first post in January provides the most context for those just now learning about the bot: https://insidegovuk.blog.gov.uk/2024/01/18/the-findings-of-our-first- generative-ai-experiment-go Read more.
Short video walking through all disruptions leading up to and after storm #Conall . Data on disruptions were copied from https://rijdendetreinen.nl. Read more.
Seems the worst of storm #Conall for rail passengers in the Netherlands was seen the morning after with broken overhead wires and over-running engineering works during part of the early morning. Read more.

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 1 - 2 of SPY×FAMILY. View activity.
Pesky watched episode 9 of Dandadan. View activity.
Pesky watched episode 9 of Ranma 1/2 (2024). View activity.
Pesky watched episode 8 of Ranma 1/2 (2024). View activity.