Amy

Oh yeah, I totally get that.

When I’m doing something for fun, I’m far more interested in the process than the end result, so I’ll do everything from first principles. And probably never finish before I move on to something else. But that’s fine.

If it’s something I need to get done, on the other hand, then by the time I’ve started we’re probably already into crisis mode, and so getting it complete as quickly as possible becomes the goal. Then I’m all for finding whatever shortcuts I can.

Fortunately I’ve explored a enough topics (particularly in programming) for fun by now that I have enough background knowledge to be good at it for a career. Experience does build up, and even if you’re jumping around all over the place, eventually you’ll start to see the bigger picture.

Ouch, this one is too real!

Well I’d kind of known since forever in a “ha ha, but everyone feels like that though, right?” way. Then some ADHD memes randomly came up on Youtube, and I realized that it was me, exactly. The same thing happened with egg_irl a while earlier, and since doing something about that had made my life much better, I went to see a psychiatrist, who immediately agreed that I had ADHD and prescribed me some drugs.

It also didn’t help that I’m predominantly-inattentive type, which is apparently more common in women (surprise!)

Same.

Me: Oh! A chance to do all the things that have been building up on my checklist!
Brain: But what about all these other things I just thought of? And you still haven’t even started learning Korean…

Yes, CTEs are awesome. Especially when you don’t force materialization and the optimizer can work its magic.

I’ve had a lot of fun with window functions as well.