my alt accounts
@mcmoots - foodie stuff. May contain un-CW'd meat & booze.
@flyingtoaster - the lewd one. Follow requests welcome from anyone (of legal age), if I reject yours it doesn't mean I don't like you.
@mcmoots - all-purpose backup account in case something happens to weirder.earth.
@mcmoots - unused, but someday I might want to toot with LaTeX?
weirder.earth admin notice
I'm making some security changes that will require at least one reboot of the web server. Hopefully only very short service interruptions, fingers crossed.... #WeirderAdmin
sql code review request
If anyone is good at #PostgreSQL #SQL query optimization, what I'm running is here: https://github.com/mcmoots/mastodon-nonsense/blob/master/custom-emoji-count.sql
🚨 weirder.earth admin notice
I poured molasses on the server.
By which I mean the query I wrote for our custom emoji popularity contest is taking a long-ass time to run. And that's just the test version that looks at just the past 2 days of toots.
If things seem slow to load right now, it's not you, it's me. I'll try to run the full version sometime when most of us are asleep, I think late night Pacific / morning Europe ought to be a good bet?
🚨 RETROACTIVE W.E DOWNTIME ALERT 🚨
I tried to fix a docker thing in order to run that query about what emoji people use, and uhhhh that was an exciting 15 minutes full of error messages. But we're back!
I'm actually immune to baby shark, because every time my brain starts it, it always morphs into Squirrels.
Sorry everyone turns out I'm out of amaranth seeds.
And I got no actual sprouts from that whole packet (except a few that I started indoors and then forgot to water oops). I guess there's still slender hope for some of the ones I planted a few weeks back but basically F- will not buy again bah humbug.
I'm not sure what they do for bar-le-duc - you'd get something completely different if you measured us both with society's official femininity ruler, we'd come out as scribbles. and so what keywords do you need a way I didn't actually puke. but I didn't, I was just a journal with a consolation prize masters was one of those, it's so worth it! Also the Vitamin D supplement to 4000 IU.
Current mood, basically these noises https://www.berkeleyside.com/2019/07/18/listen-haunting-sound-of-gray-fox-barking-at-berkeley-man-and-his-poodle
A thing I've been wanting to try sometime is to give my real birthdate + a small number of fakes to someone who's into astrology, and see if they can guess which is real. Like, it'd be an interesting get to know you exercise.
I feel like I fit my stereotypes pretty well, but have no idea if that's just the Forer effect or if it's a genuine product of reading astrology books at a formative age & adopting the traits I was supposed to have.
Cars are bad and people who drive them should feel bad.
Especially people who don't use the opposing lane to pass bicycles when it's fucking empty.
Double especially people who pass safely and courteously in the opposing lane while leaning out their window to tell cyclists to stop taking the lane, because "slow vehicles stay right in the door zone".
Is there science fiction that predicted antivaxers?
Not like, people rejecting cures and embracing disease because they have deeply-held religious objections or w/e, but people rejecting cures and embracing disease because they just kind of don't trust anything and/or get spun up about extremely unlikely pet theories.
Plants, mushrooms, cats, food, bikes, health care data science.
A community that skews thoughtful and weird. Everyone who abides by the code of conduct is welcome, thoughtful weirdos most of all! :)