I wrote this a few days ago. Finding gaps in time series is a typical problem in data engineering. Although you can solve it in your programming language of choice, it can be done in pure SQL. Here’s how to approach the problem in Redshift.
I’d love to have more things I could do on my Kindle, I love this device. But I’m still not sure if it’s rootable (I suspect no, it’s the late 2020 model). Maybe next year I’ll check (when a new model appears and I’m not so scared of bricking it and needing a replacement).
I have been in the technical evaluation of candidates, and I try to make it as close to the real work as possible. I don’t like requiring bullshit “implement a red-black tree on the whiteboard” type of problems. We have a very easy take home, talk about it, programming languages, and after a while you get a sense for the candidate and can ask some more probing questions. That at least are close to real work scenarios.