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 🤓

Adulting much today. Lots of slow leaks that need plugging 😩

Shower head broke, shower hose leaks, various siphons leak or are straight inoperable for years and the kitchen sink armature is a rusty clump by now.