#rawrs — Public Fediverse posts

Completely unrelated to my last few posts: how the FUCK does a Typescript Map's .forEach() method generate a race condition? Why is it executing lines *after* the .forEach *before* the anonymous function is finished for all elements?

>"orange juice"
>look inside
>yellow

fun fact:

rerr

why the fuck is "matzo not suitable for passover" a thing

who looks at matzo and thinks "hm, yes, I'd like to have this OUTSIDE of when I'm religiously required to"

there's too many boxes for it to be some niche strain of masochism

it's nice to come back to the fediverse after a while of not being here to find that, yep, there is still a Therra

Hm, looks like evaluating formulas is something Excel handles itself? I've gotten so close to doing everything without a COMObject, but it seems neither ImportExcel nor OfficeOpenXML can evaluate formulas to populate a CSV.

Damn, stumbled at the finish line…

so it turns out that re-planning my Powershell automation from scratch rather than just trying to emulate the steps I take manually makes things go a lot another
The task that had previously taken weeks to do shoddily took a couple of days and looks much prettier.

Have you ever looked at a sudoku puzzle and thought "man, if only I had to do some linear algebra to solve this?" If so, I… can't relate, but good news! I made a sudoku about eigenvectors anyway!
https://logic-masters.de/Raetselportal/Raetsel/zeigen.php?id=000QBD

This tumblr post lives rent-free in my head.

continuing to have Extremely Rare Powershell Problems
today's episode: "exporting my PSCustomObject[] to CSV works fine, but exporting to XLSX adds random formulas to some cells that should be empty"

Powershell question: I want to do string.replace on every NoteProperty in a PSCustomObject. My current approach is to run a foreach on (Get-Member -MemberType NoteProperty).Name. Is there a better way?

@gabboman @alexia Two quick questions:

1. In mobile browser, is there a way to see who reacted with off-server emotes? I can long-press on stuff like Likes or :drgn_3c_evil:s to see who reacted with those, but for something like a pawprint or someone's custom fursona emote, that's not available. I've seen that I can just tap it in the Android app, but can't figure out if it's possible in browser.
2. In the app, is there a way to change the theme? I haven't been able to find that menu, in contrast to the easily-visible palette button in the browser view.

Fun fact! If you put your ear up to a dragon, you can hear what it's like to get eaten by a dragon.

it's so cool that powershell hashtables have a .keys property that won't even crash when you give it an index like [0]
so, $table.keys[0] probably returns whatever it considers its first key, right?
…right?

so apparently Excel scripts don't work when MS365 or whatever is down
which, I mean, I guess at its core it is an API so I guess it makes sense in a way
but why is it not like a locally-available… module or whatever JS does? it's fucking Excel.

you can bite woots!??!?
:wvrnScream: :wvrnScream: :wvrnScream: :wvrnScream: :wvrnScream: :wvrnScream:

…you can bite people on wafrn?
:wvrnScream: :wvrnScream: :wvrnScream: :wvrnScream: :wvrnScream: :wvrnScream:

On this episode of Pancake Man Does A Thing, infamous Italian-American Mario Mario becomes so consumed by anger that all he can do is punch and kick. In this mood, he crashes the local economy, slaughters the wildlife, steals a cultural artifact, and then harasses a bird.

wake up babe new hour-long pancake man video just dropped. you'll never believe it: it's about not pressing the A-button in SM64
…okay, and also not using most of the rest of the controller, too
https://www.youtube.com/watch?v=-7VhlsqeeqI

okay, putting powershell on the backburner for a bit, I think. there's one more thing I could handle with it, but it's for a problem that's going away soon so it's not really worth it.
next up: using autohotkey to download a bunch of files from a site that doesn't have an api

Hey, to anyone more familiar with AO3 search/filtering:
Is there a way to find all fics with a ship that includes one specific character, but not being choosy about the other half of the ship?

This unauthorized fucking thing shows up in your room and asks for your snacks. How do you respond?

https://www.furaffinity.net/view/62264149/

oh online tutorials, please give me resources so I can practice
"you use this function to do an api call, then parse the response with whatever you're comfortable with"
okay what does that look like though. imagine I'm stupid
":) :) moving on, 20 minutes on anonymous functions"

is there a service I can just like…
practice doing API calls at
mostly to learn the formatting and structure for a couple languages

so I decided to see what wplace looks like around JKR's castle (y'know, the one with black mold (allegedly))
and, while I expected something like this, the sheer degree of it is mindblowing. good job everyone

also look at this RAD AS HELL trans/gay pride Samus

saw a crow on my commute
today will be a good day I think