Joerg Jaspert :debian:
ganneff.fulda.social.ap.brid.gy
Joerg Jaspert :debian:
@ganneff.fulda.social.ap.brid.gy
@debian developer, OpenPGP Key 0xDB16CF5BB12525C4

🌉 bridged from ⁂ https://fulda.social/@Ganneff, follow @ap.brid.gy to interact
#pastpuzzle 425
🟩🟩🟨🟥 (+13)
🟩🟩🟩🟩 (0)
▪️▪️▪️▪️
▪️▪️▪️▪️

2/4 🥈
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
January 16, 2026 at 5:44 AM
#pastpuzzle 216
🟥🟥🟨🟥 (-226)
🟩🟥🟥🟩 (+140)
🟩🟩🟥🟩 (+30)
🟩🟩🟩🟩 (0)

4/4 🟩
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
January 15, 2026 at 5:49 AM
#pastpuzzle 424
🟩🟩🟩🟥 (+1)
🟩🟩🟩🟥 (-1)
🟩🟩🟩🟩 (0)
▪️▪️▪️▪️

3/4 🥉
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
January 14, 2026 at 1:40 AM
#pastpuzzle 423
🟩🟥🟥🟥 (-152)
🟩🟥🟥🟩 (+40)
🟩🟩🟩🟩 (0)
▪️▪️▪️▪️

3/4 🥉
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
January 13, 2026 at 11:52 AM
Morgen gibt es hier in #Fulda dann also #distanzunterricht. Bin gespannt wie gut das funktionieren wird. Vermutlich wieder stark Lehrkraftabhängig.
January 11, 2026 at 7:34 PM
#pastpuzzle 215
🟥🟥🟨🟥 (-21)
🟩🟩🟩🟩 (0)
▪️▪️▪️▪️
▪️▪️▪️▪️

2/4 🥈
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
January 11, 2026 at 10:07 AM
So we had a problem on the mirrors for #debian #bookworm - appears the wrong stable #openpgp key got used to sign it. The one from #trixie was in use.

The "only" implication here is people who pin their debian sources to specific keys, their #apt will complain. That's annoying, which is why we […]
Original post on fulda.social
fulda.social
January 15, 2026 at 4:33 PM
In the middle of #Debian point #releases. Just finished the process for #debian #trixie #debian13 and now about to start the #bookworm #Debian12 run.

(Obviously me doing the finishing steps "only" for the work that the release team prepared over the last weeks).
January 10, 2026 at 10:42 AM
#pastpuzzle 210
🟩🟩🟩🟥 (+1)
🟩🟩🟩🟥 (-1)
🟩🟩🟩🟩 (0)
▪️▪️▪️▪️

3/4 🥉
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
January 7, 2026 at 7:05 AM
Warum sind eigentlich so viele "So machst Du Dein Multiroom Audio Setup" Seiten immer in der Form "Stell Lautsprecher auf, Starte App, Verbinde Lautsprecher mit Wifi".

Zentral nen Verstärker, paar Kabel und dazu passende Lautsprecher? Schwer zu finden.

ICH WILL KEINE SCH.... App und möglichst […]
Original post on fulda.social
fulda.social
January 5, 2026 at 2:40 PM
Morgen (nachmittag) fahren wir zu unserem Häuslebauer, Mittwoch/Donnerstag ist Bemusterung. Natürlich muss man sich entsprechend vorbereiten, bei mir zusätzlich noch die komplette Elektroplanung soweit haben, dass die danach die Dosen in die Wände packen können.

**EIGENTLICH** bin ich damit […]
Original post on fulda.social
fulda.social
January 5, 2026 at 11:07 AM
I do have another blog where I sometimes post things. Tech related mostly.

This time it is about AI slop and their shitty crawlers and how i deployed iocaine behind Caddy, and all in docker, to fight against them.

(Repost, original post got deleted in a server migration) […]
Original post on fulda.social
fulda.social
January 3, 2026 at 9:10 PM
And I do have a blog beside the house construction one too. I do post there, seldom, but today I got something techie to write about even.

Got one more server of mine protected by iocaine, good by AI crap bots.

https://blog.ganneff.de/2026/01/ai-slop.html

#caddy #caddyserver #iocaine #docker […]
Original post on fulda.social
fulda.social
January 3, 2026 at 5:22 PM
#pastpuzzle 211
🟩🟥🟥🟥 (+55)
🟩🟩🟩🟥 (-2)
🟩🟩🟩🟥 (+3)
🟩🟩🟩🟥 (+1)

x/4 🟥
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
January 3, 2026 at 9:07 AM
Wir haben soeben Mikrowellenpopcorn in der Pfanne gemacht (wir haben keine Mikrowelle). Geht erstaunlich gut.

#popcorn #Fedieltern
January 1, 2026 at 9:38 PM
#pastpuzzle 197
🟩🟨🟥🟨 (-186)
🟩🟩🟩🟩 (0)
▪️▪️▪️▪️
▪️▪️▪️▪️

2/4 🥈
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
December 30, 2025 at 11:42 AM
#pastpuzzle 204
🟩🟩🟥🟥 (-7)
🟩🟩🟥🟥 (+12)
🟩🟩🟩🟥 (+5)
🟩🟩🟩🟥 (+4)

x/4 🟥
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
December 25, 2025 at 2:26 PM
Reposted by Joerg Jaspert :debian:
Package managers keep using git as a database, it never works out.

https://nesbitt.io/2025/12/24/package-managers-keep-using-git-as-a-database.html
Package managers keep using git as a database, it never works out
Using git as a database is a seductive idea. You get version history for free. Pull requests give you a review workflow. It’s distributed by design. GitHub will host it for free. Everyone already knows how to use it. Package managers keep falling for this. And it keeps not working out. ## Cargo The crates.io index started as a git repository. Every Cargo client cloned it. This worked fine when the registry was small, but the index kept growing. Users would see progress bars like “Resolving deltas: 74.01%, (64415/95919)” hanging for ages, the visible symptom of Cargo’s libgit2 library grinding through delta resolution on a repository with thousands of historic commits. The problem was worst in CI. Stateless environments would download the full index, use a tiny fraction of it, and throw it away. Every build, every time. RFC 2789 introduced a sparse HTTP protocol. Instead of cloning the whole index, Cargo now fetches files directly over HTTPS, downloading only the metadata for dependencies your project actually uses. (This is the “full index replication vs on-demand queries” tradeoff in action.) By April 2025, 99% of crates.io requests came from Cargo versions where sparse is the default. The git index still exists, still growing by thousands of commits per day, but most users never touch it. ## Homebrew GitHub explicitly asked Homebrew to stop using shallow clones. Updating them was “an extremely expensive operation” due to the tree layout and traffic of homebrew-core and homebrew-cask. Users were downloading 331MB just to unshallow homebrew-core. The .git folder approached 1GB on some machines. Every `brew update` meant waiting for git to grind through delta resolution. Homebrew 4.0.0 in February 2023 switched to JSON downloads for tap updates. The reasoning was blunt: “they are expensive to git fetch and git clone and GitHub would rather we didn’t do that… they are slow to git fetch and git clone and this provides a bad experience to end users.” Auto-updates now run every 24 hours instead of every 5 minutes, and they’re much faster because there’s no git fetch involved. ## CocoaPods CocoaPods is the package manager for iOS and macOS development. It hit the limits hard. The Specs repo grew to hundreds of thousands of podspecs across a deeply nested directory structure. Cloning took minutes. Updating took minutes. CI time vanished into git operations. GitHub imposed CPU rate limits. The culprit was shallow clones, which force GitHub’s servers to compute which objects the client already has. The team tried various band-aids: stopping auto-fetch on `pod install`, converting shallow clones to full clones, sharding the repository. The CocoaPods blog captured it well: “Git was invented at a time when ‘slow network’ and ‘no backups’ were legitimate design concerns. Running endless builds as part of continuous integration wasn’t commonplace.” CocoaPods 1.8 gave up on git entirely for most users. A CDN became the default, serving podspec files directly over HTTP. The migration saved users about a gigabyte of disk space and made `pod install` nearly instant for new setups. ## Go modules Grab’s engineering team went from 18 minutes for `go get` to 12 seconds after deploying a module proxy. That’s not a typo. Eighteen minutes down to twelve seconds. The problem was that `go get` needed to fetch each dependency’s source code just to read its go.mod file and resolve transitive dependencies. Cloning entire repositories to get a single file. Go had security concerns too. The original design wanted to remove version control tools entirely because “these fragment the ecosystem: packages developed using Bazaar or Fossil, for example, are effectively unavailable to users who cannot or choose not to install these tools.” Beyond fragmentation, the Go team worried about security bugs in version control systems becoming security bugs in `go get`. You’re not just importing code; you’re importing the attack surface of every VCS tool on the developer’s machine. GOPROXY became the default in Go 1.13. The proxy serves source archives and go.mod files independently over HTTP. Go also introduced a checksum database (sumdb) that records cryptographic hashes of module contents. This protects against force pushes silently changing tagged releases, and ensures modules remain available even if the original repository is deleted. ## Beyond package managers The same pattern shows up wherever developers try to use git as a database. Git-based wikis like Gollum (used by GitHub and GitLab) become “somewhat too slow to be usable” at scale. Browsing directory structure takes seconds per click. Loading pages takes longer. GitLab plans to move away from Gollum entirely. Git-based CMS platforms like Decap hit GitHub’s API rate limits. A Decap project on GitHub scales to about 10,000 entries if you have a lot of collection relations. A new user with an empty cache makes a request per entry to populate it, burning through the 5,000 request limit quickly. If your site has lots of content or updates frequently, use a database instead. Even GitOps tools that embrace git as a source of truth have to work around its limitations. ArgoCD’s repo server can run out of disk space cloning repositories. A single commit invalidates the cache for all applications in that repo. Large monorepos need special scaling considerations. ## The pattern The hosting problems are symptoms. The underlying issue is that git inherits filesystem limitations, and filesystems make terrible databases. **Directory limits.** Directories with too many files become slow. CocoaPods had 16,000 pod directories in a single Specs folder, requiring huge tree objects and expensive computation. Their fix was hash-based sharding: split directories by the first few characters of a hashed name, so no single directory has too many entries. Git itself does this internally with its objects folder, splitting into 256 subdirectories. You’re reinventing B-trees, badly. **Case sensitivity.** Git is case-sensitive, but macOS and Windows filesystems typically aren’t. Check out a repo containing both `File.txt` and `file.txt` on Windows, and the second overwrites the first. Azure DevOps had to add server-side enforcement to block pushes with case-conflicting paths. **Path length limits.** Windows restricts paths to 260 characters, a constraint dating back to DOS. Git supports longer paths, but Git for Windows inherits the OS limitation. This is painful with deeply nested node_modules directories, where `git status` fails with “Filename too long” errors. **Missing database features.** Databases have CHECK constraints and UNIQUE constraints; git has nothing, so every package manager builds its own validation layer. Databases have locking; git doesn’t. Databases have indexes for queries like “all packages depending on X”; with git you either traverse every file or build your own index. Databases have migrations for schema changes; git has “rewrite history and force everyone to re-clone.” The progression is predictable. Start with a flat directory of files. Hit filesystem limits. Implement sharding. Hit cross-platform issues. Build server-side enforcement. Build custom indexes. Eventually give up and use HTTP or an actual database. You’ve built a worse version of what databases already provide, spread across git hooks, CI pipelines, and bespoke tooling. None of this means git is bad. Git excels at what it was designed for: distributed collaboration on source code, with branching, merging, and offline work. The problem is using it for something else entirely. Package registries need fast point queries for metadata. Git gives you a full-document sync protocol when you need a key-value lookup. If you’re building a package manager and git-as-index seems appealing, look at Cargo, Homebrew, CocoaPods, Go. They all had to build workarounds as they grew, causing pain for users and maintainers. The pull request workflow is nice. The version history is nice. You will hit the same walls they did.
nesbitt.io
December 24, 2025 at 4:49 PM
#pastpuzzle 203
🟩🟥🟥🟥 (-118)
🟩🟩🟥🟥 (+15)
🟩🟩🟨🟨 (-27)
🟩🟩🟩🟩 (0)

4/4 🟩
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
December 20, 2025 at 10:28 AM
#pastpuzzle 200
🟩🟥🟥🟩 (+170)
🟩🟩🟥🟩 (+40)
🟩🟩🟥🟩 (+20)
🟩🟩🟩🟩 (0)

4/4 🟩
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
December 18, 2025 at 5:58 AM
#pastpuzzle 410
🟩🟩🟥🟥 (-41)
🟩🟩🟥🟩 (-10)
🟩🟩🟩🟩 (0)
▪️▪️▪️▪️

3/4 🥉
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
December 17, 2025 at 8:42 AM
Beim ersten vertippt...

#pastpuzzle 253
🟥🟨🟩🟨 (-1695)
🟩🟥🟩🟨 (+105)
🟩🟩🟩🟥 (-1)
🟩🟩🟩🟥 (+4)

x/4 🟥
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
December 13, 2025 at 2:19 AM
#pastpuzzle 407
🟩🟥🟨🟥 (+96)
🟩🟨🟥🟥 (-285)
🟩🟩🟥🟩 (-30)
🟩🟩🟩🟩 (0)

4/4 🟩
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
December 12, 2025 at 6:20 AM
#pastpuzzle 194
🟩🟨🟥🟥 (+124)
🟩🟥🟥🟩 (+50)
🟩🟩🟥🟩 (-40)
🟩🟩🟩🟩 (0)

4/4 🟩
https://www.pastpuzzle.de
past puzzle
Errate das gesuchte Jahr mit Hilfe von 4 historischen Ereignissen. Ein von Wordle und Geschichte inspiriertes Spiel.
www.pastpuzzle.de
December 10, 2025 at 6:21 AM