I grew up in southern Germany, speaking the local dialect. As a young adult, I thought I could speak accent free German. I couldn't have been more wrong. Many people in Hamburg and Berlin rightfully guessed that I'm…
Cuisine in Europe is shaped by climate, soil and former political entities. You'll find similar cuisine in and around the alps, along the north sea coast and around the baltic sea. While the people eating the same food…
Western Poland used to be German, but all the Germans left/got expelled. After WW2 it was resettled with Poles from Eastern Poland, nowadays Ukraine and Belarus. Which makes traveling from Berlin to Poznan or Wroclaw an…
The whole idea of making train tickets extremly cheap is to make it "competitive" to cars. Trains are already cheaper to use than cars for a lot of people. But many people already own a car and have to pay the fixed…
Because I can just write SQL to access all my data. The data comes from CSVs, SQLite, MySQL, Postgres, ... I can write SQL everywhere. I write SQL from within my R scripts, I write SQL from within my Python scripts. SQL…
DuckDB is a column-oriented database. This is why it's so fast compared to SQLite for a lot of analytical queries. CSV is a row-based format. DuckDB has to load it completley to memory before it can run any queries.…
On the contrary, the need for UUIDs is growing. Once you have multiple users collecting and editing data for a central database, you'll run into primary key conflicts. Of course not, if your users are constantly online…
I grew up in southern Germany, speaking the local dialect. As a young adult, I thought I could speak accent free German. I couldn't have been more wrong. Many people in Hamburg and Berlin rightfully guessed that I'm…
Cuisine in Europe is shaped by climate, soil and former political entities. You'll find similar cuisine in and around the alps, along the north sea coast and around the baltic sea. While the people eating the same food…
Western Poland used to be German, but all the Germans left/got expelled. After WW2 it was resettled with Poles from Eastern Poland, nowadays Ukraine and Belarus. Which makes traveling from Berlin to Poznan or Wroclaw an…
The whole idea of making train tickets extremly cheap is to make it "competitive" to cars. Trains are already cheaper to use than cars for a lot of people. But many people already own a car and have to pay the fixed…
Because I can just write SQL to access all my data. The data comes from CSVs, SQLite, MySQL, Postgres, ... I can write SQL everywhere. I write SQL from within my R scripts, I write SQL from within my Python scripts. SQL…
DuckDB is a column-oriented database. This is why it's so fast compared to SQLite for a lot of analytical queries. CSV is a row-based format. DuckDB has to load it completley to memory before it can run any queries.…
On the contrary, the need for UUIDs is growing. Once you have multiple users collecting and editing data for a central database, you'll run into primary key conflicts. Of course not, if your users are constantly online…