Clickhouse: Import compressed JSON fast

The MVG Observatory Project collects real-time departure data from Munich鈥檚 public transport system. The data is organized hierarchically: the top level contains date-based folders, each containing subfolders named after station IDs. These station folders hold multiple JSON files that capture departure information throughout the day. Each station鈥檚 data is stored in two types of files: *_body.json and *_meta.json. The body files contain either API error messages or JSON arrays of responses, which are imported into the mvg....

October 21, 2024 路 7 min 路 1444 words 路 Robert

Fly with Sensible Photo Equipment

I got dragged into the rabbit hole of taking analog photos about a year ago and enjoying it since. But when you want to board a plane with your camera and a bunch of film rolls you might ask yourself: What to do with it during the x-ray at the security check. Will it harm or destroy my film? Film condition This concern is valid for a film that is either new or exposed and winded back which therefore is unprocessed....

April 22, 2024 路 5 min 路 937 words 路 Robert

TIL: 'dot_clean' in macOS

When switching between multiple systems including macOS you may have notices thoses strange looking files starting with ._. They regularely break Switch firmware upgrades and might be in the way during other filesystem operations as well. There are multiple solutions out there in the wild including removing them or moving them away using rsync. The most convinient way on macOS is using the dot_clean command which is shipped with macOS by default....

April 7, 2023 路 1 min 路 103 words 路 Robert

Advent of Code - RocketLang Edition

This years Advent of Code is a little special because I use my own language RocketLang to solve the puzzles. I鈥檒l probably explain this in a seperate post at some point so lets have a look at the first puzzle of the year: Problem The task is to calculate the amount of calories they are carrying. For example: 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 This shows us 5 elves with different amount of items (with different calories each)....

December 1, 2022 路 2 min 路 394 words 路 Robert

馃 Blumentopf - Automated Plant Watering #2

This post misses a lot of technical details as I reconstruct the changes and implementations out of my memory and my image archive. The latest Blumentopf iteration will contain all technical details you need. In 2020 I remembered a Self-Watering Planter I printed a few years ago and thought it would be nice to reuse this one to replace my chunky prototype with a cleaner and more aesthetic version. Since I grew a lot of chilis that needed a similiar amount of water, I thought it would be easier to only use one pump and chain the pots together....

May 1, 2022 路 2 min 路 401 words 路 Robert