Lessons after five years of professional programming
21–26 of 26 posts
Re: Lessons after five years of professional programming
#22Re: Lessons after five years of professional programming
#23I guess it boils down to me thinking that anyone willing to write a list like this probably knows just enough to be dangerous (which items on this list could be, depending on how they are interpreted). So again, wait another 5-10 years and then see what you have to say on the subject.
Re: Lessons after five years of professional programming
#24Re: Lessons after five years of professional programming
#251. When performance is an issue, if you can calculate or process it at the application layer, then take it out of the database layer. order by/group by are classic examples. It’s almost always easier to scale out your application layer than your database layer. As true for MySQL on your server as it is on the sqlite in your handheld. I disagree. RDBMS are highly optimized for this kind of operations (including MS SQL…
> Code should be self readable, and if you get > to the point where it isn’t, then you may have > to rewrite few bits. This is not always > possible though, especially for temporary > hotfixes or hacks. In this case, comments are > a must. * Sometimes business decisions may not make logical sense, but someone says "do it this way." It makes sense to comment this in the code. * The code might tell you what it's doing,…
Re: Lessons after five years of professional programming
#261. When performance is an issue, if you can calculate or process it at the application layer, then take it out of the database layer. order by/group by are classic examples. It’s almost always easier to scale out your application layer than your database layer. As true for MySQL on your server as it is on the sqlite in your handheld. I disagree. RDBMS are highly optimized for this kind of operations (including MS SQL…
> Code should be self readable, and if you get > to the point where it isn’t, then you may have > to rewrite few bits. This is not always > possible though, especially for temporary > hotfixes or hacks. In this case, comments are > a must. * Sometimes business decisions may not make logical sense, but someone says "do it this way." It makes sense to comment this in the code. * The code might tell you what it's doing,…