2021-09-21 : Random Geekery

Today is September 21st — you know the rules

Whoa thanks KEXP for the reminder that it’s September 21st!

Let’s listen to that again. Haven’t found a 10 hour loop, so this’ll have to do instead.

Was just going to tweet this but I know it’ll do me good to find at random site-tidying moments.

ℹ️ Note

2024-07-21: you are so right, past me.

I remember when I was worried whether they’d warm up to us.

Not pictured: all the stuff he knocked over to get at my lap and skritching hand.

Got another SQL view somebody wants tweaked, so I’m once again figuring out the Django query version.

I got my relevant historical data over here

I got my series of calendar dates over there

Now uh the CROSS JOIN part.

[looks at query A]

[looks at query B]

now-kiss.gif

Oh Django already did the cross join when I made the dates series.

THAT IS FANCY

Soft sigh as I pull up my keyboard to report — with my good fingers — that washing dishes remains a blood sport when I’m involved.

no it’s fine. a bit showy, but fine.