<i>&quot;SELECT&quot; isn&#x27;t broken</i>. (h&#x2F;t <i>The Pragmatic Programmer</i>, by Hunt and Thomas) Junior programmers will sometimes think the problems they encounter are the fault of bugs in well-tested system software, rather than their own code. (1)<p><i>The implementers of the legacy code aren&#x27;t stupid</i>. It&#x27;s very common for junior programmers, tossed into the swamp of some codebase that&#x27;s been around for years through many different hands, think the code is junk and the original implementers were fools. Usually, it&#x27;s just that the problem is much more complicated than the juniors understand, and that&#x27;s how the code got that way.<p><i>New tools probably won&#x27;t solve the problem</i>. There&#x27;s a tendency with junior programmers to whine about the antique tools in use, convinced that the new Foobaz framework or Language X will magically clear up the issues they encounter. But the problems with code usually aren&#x27;t from the tools used to build the code - they&#x27;re from failure to understand the requirements, and time&#x2F;scope&#x2F;resource constraints on development.<p><i>Perfect isn&#x27;t as important as finished</i>. It&#x27;s easy to get caught up in perfectionism. It&#x27;s a good excuse to avoid releasing something you find embarrassing into the world. But the more time you squander polishing that turd, the less time you have for the next tur... er, cool new project.<p><i>If you can&#x27;t write a test for it, you don&#x27;t understand it well enough</i>. Writing good tests is hard. It&#x27;s easy to fall into a trap of &quot;That&#x27;s too hard to test. I&#x27;ll just sort of check manually to make sure it works&quot;. This <i>will</i> bite you in the ass later!<p>(1) My first really good bug as a junior programmer actually <i>was</i> a &quot;SELECT is broken&quot; kind of problem (technically, mmap() was broken). I went to a great deal of effort to prove to the senior programmers (and then IBM) that my code was actually correct and I had an OS bug. And if some junior programmer came to me today and said a deep system call like mmap() was broken, I&#x27;d laugh at her and tell her to check her code. So sometimes, SELECT actually is broken - just not as often as junior programmers think.