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

@evan Are you in Halifax right now? I would swear in a court of law that I recognized that moustache in traffic crossing the MacKay bridge into Dartmouth this evening.

@phillycodehound @tchambers @jeff Cars are going to become like guns. If you want to own one for your own personal enjoyment, fine, but you have to use it over there, away from people.

I can't wait for this. Think about the car-free downtowns, cleaner air in cities, a fraction of the fossil fuels being burned, etc., not to mention the huge reduction in injuries and deaths from accidents.

@jimcarroll I just finished reading this article before I saw your post. Sure seems like it's beneficial to have a leader who has a deep understanding of economics.

https://deanblundell.substack.com/p/carneys-checkmate-how-canadas-quiet

Ooooh, man, did we have a stellar day for #solar energy production today! With electric heating, I usually don't get a day when I'm net positive until about a month from now. But after all was said and done, I'm up 12kWh despite it being between -5 and -9 Celcius for most of the day.

My favourite thing lately has been changing the default notification sound for Mastodon notifications to this one.

@evan It would make it a pain in the ass to have it automatically renew when it was nearing its expiration. Wait, not everyone uses @letsencrypt ???

@seth I abandoned Pocket Casts for @AntennaPod when they started charging for things after I bought the lifetime subscription.

@seth Clearly, you're not listening to podcasts as much as you should be.

@seth Yep! It's true. I do rock :)

@seth WinDirStat https://windirstat.net/

@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.