I think the size of this thread as well as the existence of blog posts like this means it's a mistake that's always going to be repeated. There's way too many

I think the size of this thread as well as the existence of blog posts like this means it's a mistake that's always going to be repeated. There's way too many programming gotchas to expect people to keep track of them all. Language support to avoid classes of mistakes is a great idea to me e.g. such as having a good random algorithm by default and a UUID library.