Notices by Steve Dinn (steve@social.dinn.ca)

@Morpurgo @dansup @loops @pixelfed Aaaaaannnnndroooooooiiiiiiidddddddd!

Seriously, I have horrible FoMo right now.

@evan Only by an hour.

@Mrfunkedude @dansup Oh! I thought it was just me who hadn't received their email. I thought I had hit a bug or something...Maybe I should just wait.

@evan *Is* that the point? I consider that to be pretty unhinged. If this is the case, why are they not just separate things?

@evan By "different result sets" I mean completely different columns and different data not necessarily following the same structure.

@evan I have been in a situation where stored procedures were established by the DBA and consumers of the database used them like an API, so in that case, or if I was intending to provide this kind of "API", then yes. But if I'm developing software and I'm in control of the database, then no.

I find it's a bad code smell if a particular query occurs in more than one place in your app. So using this metric, stored procedures are an unnecessary level of indirection that can lead to obfuscation.

@evan I've also seen stored procedures go completely off the rails and return completely different result sets depending on the parameter values.

Man, it's almost as if the hurricanes themselves are campaigning for climate change action.

Mastodon server admins or other experts: What could potentially cause another instance to get a 401 error when attempting to POST to my instance's inbox?

The other instance was offline for a while, and I had subsequently "Purged" it using the option in the "Moderation/Federation" admin screen to try and correct this problem. It didn't work. The other instance seems to be federating normally with other instances -- just not mine.

Any ideas?

#mastoadmin

@gotosocial Is there any way to convert a single-user Mastodon instance into a GoToSocial instance? Like, migrate the database, and use the existing key pair so I could use the same domain name and fediverse handle?

I set up my Mastodon before I knew about go to social, and I would love to have a less-resource-intensive instance.

@jessamyn @shoq @tchambers Sounds like metafilter needs a Lemmy (or similar) instance. That sounds like what you're describing to me.

@jessamyn @shoq @tchambers You could do the bare minimum today with an RSS to fediverse bridge. There are tons of those available now.

@evan If, by "celebrating", you mean heading to the in-laws' cottage for probably the last time this year (kids' school and other commitments are now getting in the way), then hell yes. Otherwise, I guess it's just another long weekend.

I have an instance of go-to-social that has been off for a long time and had been "expired" by most other instances. Even my own Mastodon instance doesn't recognize it (can't even search for my account on it).

Is there any way to salvage it, or is it just done?

#mastodon #mastoadmin

@evan Honestly, they were campaigning on the notion that Biden was too old to be running. They got what they wanted, and now they're sour about it.

@evan I get you. I just tried to put myself in the position of an American voter. They really are stuck between a rock and a hard place.

@evan Its not like things would get better under Trump.

@nixCraft Makes you wonder how much of that history is actually necessary. I mean sure it's necessary for posterity, but how much smaller would the repo be if we only kept the last 10 years?

Something something, Ship of Theseus.

@evan I think the municipal level should be the first to have its own social media. I feel like Mayors and city councillors are the ones who typically have something to say that needs to be disseminated in a timely fashion. But I totally agree with the direction this is going in :)

Governments should not be beholden to corporations for the purposes of communicating with constituents.

@evan I signed this yesterday, BTW :)