Pinned toot
Pinned toot

thoughts on my upcoming move 📦 

Okay, rapid fire: Celsius, Greco pizza, the CBC, the trans Canada walking trail, proximity to Halifax, folk music, the Harvest Jazz and Blues Festival, farmers markets... oh and let’s not forget my family! My niece and nephew have grown up nearly a year since I saw them!!!

Show thread

thoughts on my upcoming move 📦 

The place has fibre internet, which is very cool. We’ll have an extra bedroom for a home office. I’m going to get a couch, in my office, for when I need to step back and ponder my work. Amazing.

The accent... oh my gosh. People will finally sound right to me again. I can’t wait to stop correcting my own accent too and let myself sound like a maritimer again. (There are some lines I won’t cross, though – for example I’ll never call it “kwee-beck”.)

Show thread

thoughts on my upcoming move 📦 (alc mention) 

Okay more things I’m excited about... (moving to unlisted so as to not spam people)

New Brunswick has this incredible microbrewery called Picaroons (any lumberjack fans out there? jk I know there are). Their beers are *amazing* and all have really great stories and regional names. Can’t wait for next summer’s Dooryard ale, but I’ll have the Winter Warmer to, well, keep me warm ☺️

Show thread

thoughts on my upcoming move 📦 

Other things I’m keen on... hmm...

A yard. Like a front yard. Not having a a door that opens to a hallway, but just to the outside. A freaking mailbox. A garbage day.

I’m trying not to gloat or whatever, but five years living in New York has lowered my bar of a nice apartment to “oh my god, you have like a whole two rooms? Separated by a door? Amaaaaaazing.”

Show thread

thoughts on my upcoming move 📦 

One thing I’m looking forward to about living back in New Brunswick is a larger apartment with a home office (I’ll be working remotely for... ever haha).

My desk in new York is comically small, and a bigger space means a bigger desk, and enough room for me to put a lil basket on it, like a sourdough basket, for my cat to sleep in. Next to my monitor, while I work 💤 😺

@bclindner okay so, all the queries I killed were identical, a complex SELECT (I took a screenshot). So far there’s one that’s come back. I’m going to set a two-minute timeout on our Postgres install to prevent this from happening again. Two minutes is still very generous, and longer than our nginx timeout, so the API should be unaffected. Let me know if you (or, indeed, if any curious watchers) have questions!

Show thread

@bclindner haha wait, I’m see mdszy in the logs when I grep for delete... maybe
@skelly ‘s auto-delete script is running?

Show thread

@bclindner ah, forgot to say that one of the queries I found was this:

DELETE FROM "accounts" WHERE "accounts"."id" = $1

It only took a few minutes to complete though 😅

Show thread

@bclindner I’m seeing instance slowdown. iotop showed a Postgres DELETE query using a lot of disk IO and PGHero indicates there are *nine* long-running queries currently being executed. Some have been active for almost 40 minutes (whaaaat).

My theory is that a user with many status has deleted their account and Postgres is chewing through the work to make that happen. I’m monitoring, and if need be we can kill the queries in PGHero.

It’s , which is cool! Coming out as bi was hard for me, but now how I think of myself internally finally overlaps with how I present myself externally, which lifted a heavy mental burden. It was hard but so, so worth it.

Someone said earlier today that the hardest person you’ll come out *to* is yourself. It was for me, anyway. So if you’re discovering stuff about yourself only now, today is for you, too.

those three numbers? they aren’t real, they can’t hurt you

Show thread

one of the only days that Americans and the rest of the world agree on the order of the numbers. it’s like a -40° but on a calendar.

Show thread

I didn’t even mean to do this, I was just testing out a PSD of the Apple Watch mock-up and had the three worf morn photo handy.

Show thread

once again, I've forgotten to book off Canadian Thanksgiving 😪 it sneaks up on me every year and I'll just say it: American Thanksgiving is too close to Christmas. Sorry but it's true.

Show more
Mastodon for Tech Folks

This Mastodon instance is for people interested in technology. Discussions aren't limited to technology, because tech folks shouldn't be limited to technology either!