Recent blog posts
Querying S3 Tables with DuckDB
DuckDB has the ability to query S3 Tables, when this was first announced in
beta I was unable to get it to work and subsequently gave up. A little over a
year later I decided to give this a go again and now that it's generally
available, to my surprise, it just works. There's still guides on how to set
this up with nightly releases and other feature flags but nothing that shows
the generally avail
Read more.
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.
Recent toots
@niccokunzmann Seeing the thought and care put into documentation was amazing.
I'm really happy to have contributed towards that with you and Steve. Thank
you!
Read more.
@maartje @smveerman Missing curtains for reference and a lack of the overhead
rack. The picture was posted by the CEO on LinkedIn.
Read more.
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.
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 completed Sousou no Frieren 2nd Season
View activity.
Pesky completed Golden Kamuy: Saishuushou
View activity.
Pesky watched episode 12 of Golden Kamuy: Saishuushou.
View activity.
Pesky watched episode 8 - 9 of Sousou no Frieren 2nd Season.
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 Email