staticnotes.org

My current backup strategy is pretty inconsistent.

Some training sessions in my triathlon club are very popular.

London has a great rental bike scheme that makes it easy to get around the city.

In my job I often work on pipelines that process a large amount of data in batches.

This post is a response to a newspaper article I read this morning.

Setting up SSH keys is one of these things I need to do every couple of months.

This is a super small thing I stumbled upon.

In data engineering pipelines we commonly store output data in S3 buckets at various stages.

In the data engineering pipelines of my current company we use two main file formats: Parquet files for analytical workloads (columnar-storage) Avro files for transactional / event-based messages (row-storage) In Querying remote S3 files I wrote about how…

In previous blog posts, I described two DuckDB use cases for data scientists and data engineers: Querying remote parquet files and processing larger-than-memory datasets .

The book is a collection of speeches that Charlie Munger, partner of Warren Buffett at Berkshire Hathaway, gave over the years (1986 - 2007) at universities and institutions.

I use Joplin   for all my note-taking as it’s open-source, markdown-based, and has decent Desktop and Android apps.

The symptoms of this problem were the same as the ones I described in TIL how to debug a broken Nextcloud login .

The number next to related posts at the bottom of each page is the advertised post’s “similarity” to the currently viewed page (from 1.0 to -1.0).

Bent Flyvbjerg   is an economics professor at IT University of Copenhagen.

Effective prompt writing for large language models continues to be a dark art.

I really like the idea of providing different content types of my blog in separate RSS feeds.

In DuckDB use cases for data scientists: Querying remote S3 files I wrote about how I use DuckDB as a convenient way to query data from CSV or Parquet files in S3.

Today I came across the QUALIFY clause which is supported in some SQL dialects.

This morning, the top headline on the front page of my weekly newspaper was: Bets rise on bumper rate cut by Fed Investors have sharply increased their bets on half percentage point interest rate cut by the Federal reserve next week as the US central bank…

just   is just a command runner that I recently started using to define aliases for commands in my projects, e.g. build, test, or deploy commands.

One of my big recurring time sinks while doing data science work used to be trying to get my colleagues’ Jupyter notebooks to run on my machine.

When writing notes in markdown I commonly encounter the problem that I want to create an automatically numbered list with content between the items.

For the last couple of months I have come across multiple instances where I wanted to write an SQL query to apply a lower threshold to all the values in a particular column in one of our Snowflake tables.

In 2024, I was foolish enough to participate in the Vätternrundan   , which is a 315km distance bike sportive around Sweden’s second-largest lake.