MySQL Stored Procedure Programming

Name

DEV-02: Ask for help after 30 minutes on a problem

Synopsis

Following this simple piece of advice might have more impact on the quality of your code (and your productivity) than anything else in this book!

How many times have you stared at the screen for hours, trying this and that in a vain attempt to fix a problem in your code? Finally, exhausted and desperate, you call over your cubicle wall: “Hey, Melinda (or Jose or Farik or Lakshmi), could you come over here and look at this?” When Melinda reaches your cube she sees in an instant what you, after hours, still could not see (and she doesn’t even know MySQL all that well!). Gosh, it’s like magic!

Except it’s not magic and it’s not mysterious at all. Remember: humans write software, so an understanding of human psychology is crucial to setting up processes that encourage quality software. We humans like to get things right, like to solve our own problems, and do not like to admit that we don’t know what is going on. Consequently, we tend to want to hide our ignorance and difficulties. This tendency leads to many wasted hours, high levels of frustration, and, usually, nasty, spaghetti code.

Team leaders and development managers need to cultivate an environment in which we are encouraged to admit what we do not know, and ask for help earlier rather than later. Ignorance isn’t a problem unless it is hidden from view. And by asking for help, you validate the knowledge and experience of others, building the overall self-esteem and ...