The dark side of foreign keys: Deleting two rows took two hours. (Verifying that none of a large bulk of data with an FK did not reference in either of them.) => DELETE FROM metric WHERE name = 'networkin' OR name = 'networkout'; DELETE 2 Time: 6957592.469 ms (01:55:57.592)

Email newsletters I actually read: Simon Eskildsen's Napkin Math and Brandur's Nanoglyph, both very relevant to you if you follow me here. Also: Peter Attia, Clearer Thinking

Sometimes I hear a lot about another database and decide to run a little experiment against one to see whether the hype is real or not. My jaw literally fell open when I read this.

Golang Weekly notes that Go has jumped to position 7 on the TIOBE index. There's no way you'll ever get me to believe that all of C, C++, and Java are more popular than JavaScript/TypeScript, but even so, a positive sign!

Thank you asdf. This is the way. Instead of acting astonished that I encountered an extremely common error and forcing me into a 10 minute Google quest, just tell me what to do.

Happy to say that I woke up this morning completely BSOD-free! Turns out that never engaging with bullshit enterprise endpoint security snake oil in the first place has benefits in more ways than one.

Me to J. Pow as CAD continues to slip after BoC forced to cut rates even as the Fed has made a series of uncharacteristically good decisions this year and held strong.

If even half the lore from "The Tarnished Archaeologist" YouTube channel is correct, then Elden Ring is the most nuanced, comprehensive fantasy epic of all time, blowing by even Tolkien and Robert Jordan. And it seems to be correct. Absolutely breathtaking attention to detail.

Go's race detector has found 100s of bugs for me. Even when I think I'm smart and coding concurrent-safe code, I regularly screw it up. So I wonder: what's going on in languages without a race detector (most)? There are untold millions of concurrency bugs out there, guaranteed.

The remedial quality of Go's docs is frankly amazing sometimes. This is from Go 1.22's flagship math/rand/v2 package. Oh, is a PCG a PCG generator and NewPCG returns a PCG? All very enlightening. How to write words while saying nothing at all.

Ultra partisan, regime mouthpieces failing into oblivion as ever fewer people are willing to pay for propaganda, will now be shored up by tax dollars. Once again, California enshrining itself as the most regressive state in the union. It's not close. x.com/ZavalaA/status…

The most exciting part of Go 1.23 is that 1.21 is now deprecated, which means that `math/rand/v2` is universally available in all supported versions of Go, which means that rand functions are finally callable without worrying about whether rand has been seeded or not.

Neat website. Ruby's going to have a disproportionate legacy because it was coincidentally the tech stack of choice during that magical early 2010s period when so many of the super juggernauts were forming. toprubycompanies.info

I have a 20+ TB media archive. I've been waiting a decade to back it up to the cloud, hoping for prices to drop to a level I'm willing to pay. I've resigned myself at this point that it's never going to happen. For better or worse, local storage for large media is the way to go.

Yep. I’m always tempted to shoot from the hip in response to DHH’s latest antics, but after thinking on it a while, I realize he’s more right than wrong. Ruby’s perf is absurdly bad, but it matters less than you’d think. Apps are almost all DB I/O. x.com/jmduke/status/…

Best keynote of year. Skip Apple's, come to this instead.