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.
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