Currency Conversion In A Data Warehouse November 06, 2024
Imagine an ecommerce company selling pool noodles worldwide. The sales team, located in the US, works with dashboards that aggregate revenue…
By Philipp Jung, data engineer and machine learning researcher.
Finding the Closest Element in a Sorted Array November 02, 2024
A coding problem about finding the 'most central' element in an array, which can be elegantly simplified by applying some maths.
Efficient Data Export from Firestore to BigQuery October 14, 2024
I discuss two different approaches to transferring data from Firestore to BigQuery.
Synology Backup in Google Cloud Storage Archives September 26, 2024
I own a Synology DS223j NAS and went on great lengths to figure out the ideal way of backing up my data on Google Cloud Storage.
The smartest Person in a Jazz Band: Thoughts on Working in a Team June 26, 2023
I read 'The Passionate Programmer' by Chad Fowler, which made me think about teamwork.
Escaping the CSV Trap and Embracing Alternatives May 20, 2023
After half a decade of loading structured data from CSVs, I share my thoughts on data formats and their implications for data practitioners.
Tabular Data Transferring Patterns February 05, 2023
Patterns I notice in in practice when transferring and loading tabular data.
Trust October 16, 2022
Thoughts on performance under pressure.
I Underestimated The Importance of Tooling August 13, 2022
On the benefits of using the right tool for the right job.
Zeal and Dash for Reading Developer Documentation January 14, 2022
It feels really good to use Zeal and Dash to read developer documentation.
Automating Backups With Btrbk On Fedora 34 January 14, 2022
A rough guide to setting up a backup routine on a machine running Fedora 34.
Predicting the Beginning of the End January 17, 2021
With early vaccination data from the Robert Koch Institute, I run a linear regression to get an estimate to predict when the Germans will reach herd immunity.
Mutable Objects in JavaScript July 29, 2020
Mutable data structures are tricky to work with, which is a tripping wire when updating state in a React app.
Languages, Fast and Slow February 18, 2020
Some wisdom I learned from a friend about slow programming languages.
Learning Relaxations January 05, 2020
A summary of the work I did in my Master's thesis.
The Essence of Backups in Linux November 03, 2019
Fundamental thoughts on how to get started with backups on Linux.
Easy Concurrency in Python October 17, 2019
I've written a bunch of Python code that needs to run faster. Here is what I learned, easily digestible in a guide.
Testing Scientific Code - How to Get Away with Bad Code August 10, 2019
Some thoughts on how scientists can test their code.
Learn Programming without a Background in Computer Science June 29, 2019
A few ideas on how to get started with programming without having studied CS.
Nebenhörer in Berlin March 13, 2019
In 2019 habe ich an allen Berliner Universitäten Kurse belegt. Ich erzähle von meiner Erfahrung.
Was ich von Ansgar Oberholz gelernt habe February 14, 2019
Im St. Oberholz am Rosenthaler Platz habe ich Ansgar Oberholz kennengelernt und von ihm übers Gründen gelernt.
Wie ich meine morgendliche Bildschirmzeit reduziert habe January 06, 2019
Ich verbringe etwas mehr Zeit mit meinem Smartphone, als mir lieb ist. Und zeige, was ich angestellt habe, um weniger Zeit mit meinem Smartphone zu verbringen.
Fahrradverleih in Berlin October 19, 2018
Ein Vergleich von Berliner Leihfarradanbietern.
Das ganze Jahr Fahrradfahren October 19, 2018
Ein Erfahrungsbericht, wie ich im Winter in Berlin Fahrrad fahre.
A country for old men September 09, 2018
Überlegungen zum Leben in einem Land mit der ältesten Bevölkerung weltweit.