You've pointed out several ways things could have been done better in that project. They are all clearly important and hard-won knowledge. But, I have found t

You've pointed out several ways things could have been done better in that project. They are all clearly important and hard-won knowledge. But, I have found that one of those is super-duper-extremely important: know when not to program! You can just ask other SMEs (subject matter experts) for the answer!