tannenfreund87

3 ms·

1.
by tannenfreund87 1mo ago
And it's already in use. In the geospatial world we have geopackage, basically a replacement for the still ubiquitous shapefile. It's build on the idea of the earlier spatialite extension for sqlite. Then, shortly after the introd
2.
by tannenfreund87 3mo ago
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 from Bavaria.
3.
by tannenfreund87 3mo ago
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 speak a dozen di
4.
by tannenfreund87 3mo ago
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 interesting exp
5.
by tannenfreund87 4mo ago
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 costs per mont
6.
by tannenfreund87 4mo ago
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 is THE language for
7.
by tannenfreund87 4mo ago
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. Depending on the am
8.
by tannenfreund87 4mo ago
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 and never lose t