gnomon

gnomon, 18 days ago to random

Is there an idiomatic SQL (sqlite3) way of mapping a subset of selected records from a large table ("users") to unique values in a smaller table ("coupons")? It's easy enough to select all the user records not yet mapped, and to select all as-yet unmapped coupons, but then what's a nice clean way of mapping one to the other? Order doesn't matter, only that the mapping once established can be queried again in the future.

My brain is stuck thinking sequentially about this, frustratingly.

gnomon, 2 months ago to random

Get your timed mute buttons ready, folks, we're about to do a #monsterdon.

gnomon, 19 days ago to random

Get your timed mute buttons ready if you're a #monsterDontian, #monsterdon kicks off in 20 minutes!

gnomon, 3 months ago to random

Get your timed mute button ready, we're kicking off #monsterdon in about eight minutes!

gnomon, 12 days ago to random

Get your timed mute buttons ready, #monsterdon is about to watch The Pit and the Pendulum!

gnomon, 1 month ago to random

Some kind of heavy hydraulic machinery starting howling literally right outside my office window at 9:01 sharp, about 55 minutes ago, and I cannot hear a n y t h i n g. Going to be a challenging day for concentration I think.

gnomon, 7 months ago to random

For everyone getting a little bit sad about the CBC no longer broadcasting the time signal¹, please know that the NRC is still..:

• broadcasting the signal itself via shortwave²

• maintaining a "Canada's Official Time" page³

• providing a stratum-3 NTP server as a public service⁴

I configure my servers to use time.nrc.ca for reference and it brings me a small delight every time.

¹: https://www.cbc.ca/news/canada/ottawa/cbc-stops-broadcasting-national-research-council-long-dash-time-signal-1.6988903

²: https://nrc.canada.ca/en/certifications-evaluations-standards/canadas-official-time/nrc-shortwave-station-broadcasts-chu

³: https://nrc.canada.ca/en/certifications-evaluations-standards/canadas-official-time

⁴: https://nrc.canada.ca/en/certifications-evaluations-standards/canadas-official-time/network-time-protocol-ntp

gnomon, 1 month ago to random

Get your timed mute buttons ready, #monsterdon kicks off in five minutes!

I just put the DVD in the player and boy howdy, if the movie is anything at all like the intro clips we are in for a ride tonight

gnomon, 1 month ago to random

This makes twice now that The #Monsterdon Collective™ has picked films I already own and to be honest it feels a bit judgey

edit: proof

gnomon, 9 months ago to random

Yes!

gnomon, 5 days ago to random

I am the opposite of a morning person: generally when I wake up I'm feeling the worst I do all day, and that gradually improves as a shower and have breakfast. But this morning I'm already feeling loads better than I did at every point yesterday! So that's nice.

I don't have a working theory about why, but yesterday I just felt super low energy all day - sleepy, but also physically tired as if I had worked hard all week (dear reader, I had not), aching joints, the whole nine yards.

gnomon, 9 months ago to random

It is time to ask people on the internet about their cats

gnomon, 1 year ago to random

Me: I want a device that watches over me and the people I love while we sleep. It must be capable of such keen, decisive action that even absent actual flames it can rouse slumberers early enough to save their lives. It must last a decade and cost $30.

Smoke alarm manufacturer: we understand and accept the solemnity of this request, and we have built it.

Me: now I want something that will scream like a demon every time I boil water.

Smoke alarm manufacturer: you're not going to believe this

gnomon, 4 months ago to random

@geerlingguy hey, am I recognizing one of those DJI lav mic recorders in your ARM @ CES video? What do you think of them?

gnomon, 5 months ago to random

Wait, is it raining out there? What the heck, that wasn't in the forecast! I was going to go for a bike ride. Now I guess I'm going for a wet bike ride. #dlws

gnomon, 2 months ago to random

Lotta snow out there today. Getting around on two wheels was a bit challenging. Tomorrow's going to be harder. 😬

Gotta do it though.

#dlws

gnomon, 6 months ago to random

Does anyone out there have strong positive or negative opinions about those extremely pretty Miniware MDP-XP variable power supplies?

gnomon, 7 months ago to random

In a cabin in a forest on the edge of a lake. Flames in the fireplace, rain in the trees, honeynut squash slow roasting in the oven.

gnomon, 9 months ago to random

can't wait to heck off into the forest for like a week

gnomon, 3 days ago to random

i hab a code

gnomon, 22 days ago to random

When I pass on I want there to be a party, a proper one with music and drinks and dancing. I want professional staff, generously paid and properly treated by all; the band too; and I want three solemn volunteers at the exit to ensure everyone gets home all right, by themselves or in a hired car or with an escort if need be, and to extract a promise: that each attendee, before the next full moon, will take one task from their neighbour's todo list & fulfill it to the very best of their ability.

gnomon, 26 days ago to random

Blurgh, in the last 25-30 minutes the back of my throat has developed that worrying little ache that usually precedes a cold or a flu. Haven't felt that in a long time, at least a couple of years. Maybe I'm just being paranoid, but I'm skipping Katie's and my dance lesson tonight. :-\ Means missing something I was looking forward to, but better to not take risks with other folks's health. (I hope it's not actually an illness coming on but rather, like, a bad pollen day or something.)

gnomon, 1 month ago to random

So @k8eb wants us to watch Spongebob

And, like

Ma'am. We are not going back and watching eleven seasons of this show.

...

...are we..?

gnomon, 1 month ago to random

Yesterday Katie and I attended our first dance class together. It was fun! It's been a long time since I've done anything like that.

gnomon, 3 days ago to random

I am NOT going to watch a four hour YouTube video about a star wars hotel