In this video I go over a couple "light bulb" moments I have had. Going forward I will make sure application code is "table driven" via triggers when at all possible. I will also try to ensure any particular aspect of the UI can completely rebuild from scratch with minimal effort.