I thought it might be funny and useful (as we are all learning from mistakes) to share our biggest (or fairly large) mistakes in coding. I made (too) many in my 40 years coding career, but I will start with the 2 recent ones (from this week):
Programmed a very long-running routine, went for a walk as I knew it will run for at least one hour and noticed upon return that I forgot to delete the “LIMIT 100” in my SQL statement before putting it into production. (Lessons learned: always(!) use use Pragmas with a check for DebugBuild).
Optimized another long running Programm to use workers (for the first time). Cool stuff and I succeeded. While I uploaded the app to my customer’s Linux server it came to my mind to check on how many cores it is running. Guess the answer: ONE! . (Lessons learned: life is not fair )