Adulted much and did lots of mundane tasks in the house recently. Including some plumbing that was really overdue. Water starts to become my arch nemesis in our ageing building and leaks really do not improve over time.

On my list were 4 siphons, that needed replacement, a shower hose and a shower head. Some of this stuff was only held together by varnish and replacing all this was a mess.

Anyway, what I find really great is that some of the required parts could be obtained in environmental friendly packaging. Namely the shower head and three of the siphons. No further plastic was in the cartons. Really appreciate this.

Sadly that was not the case for the shower hose and the new kitchen armature. Especially the last came with formed foam. That could really do without too.

Oh yeah and remember the unexpected findings in the washing machine from https://beko.famkos.net/2022/06/21/6686269/ ? This time it was Siemens 0, Grass Trimmer 7 and I really wonder “will they ever learn?” This time the sieve was toast and needed replacement 😠

Indexing in MySQL by yahwho (yahwho.org)
I have been working a lot with JavaFX recently and it’s been a while since doing any SQL work. After loading my project and running a few test commands I was pretty shocked to see that the SELECT statements were taking almost 15 seconds to produce a response! Thankfully I quickly remembered I need...

Indeed. Always worth to take a closer look at indexes when SQL queries are too slow 👍

Mastodon Does Microformats, ActivityPub Does Check-Ins and Travel Plans by Ton Zijlstra (zylstra.org)
I hadn’t really looked, but it turns out that Mastodon has incorporated microformats. It has h-feed and h-card, h-entry (a status), and h-cite (a boost). Plaint text properties (p-), e-content, and link properties (u-) are implemented. Indeed, they all surface when looking at a profile’s HTML so...

Mastodon Does Microformats, ActivityPub Does Check-Ins and Travel Plans: https://www.zylstra.org/blog/2022/11/mastodon-does-microformats-activitypub-does-check-ins-and-travel-plans/

A Very Silly Workaround to Verify the @scalzi Account on Twitter is Actually Me, John Scalzi by John ScalziJohn Scalzi (whatever.scalzi.com)

Because the blue check mark on Twitter is now a symbol of subscription status, rather than being a symbol that Twitter has verified that an account is held by the person it purports to represent, I offer the following, with apologies for the occasional use of the third person, and with informational bits up front […]

This is why especially the IndieWeb people are adamant about that everyone should be their own identity provider on the net and not give that role away to any silo|3rd party. Yes, a domain costs (just like a phone number). Even if it just holds a single page referencing “official” profiles. I’m aware that this isn’t an identity check but it’s enough to tell profile equivalence and this is the more important part.

BTW: Love your books 🤓