Monthly Archives: May 2015

Will TopCoder Make You a Better Programmer?

I am going to answer this question by summarizing  my experience from  solving over thirty TopCoder practice problems. I solved mostly the Level 1 problems and at least one Level 2 problem from the problem archive. There are also Level 3 problems but they are quite difficult. You can find my ProjectEuler solutions on my GitHub site. Many of the solutions have passed the TopCoder System Test but some solutions are not completely tested yet and may not work correctly. What TopCoder Offers The problems Continue reading →

How to Change Posh-git PowerShell Colours

If you started using posh-git PowerShell in Windows, the Git PowerShell colours you see are the ones below. As you can see, the colours on my screen are a little difficult to see. I think this is caused by the rendering of green and blue on Windows machines that produces colours that are more difficult to see than the same colours on a Unix machine. After making some adjustments to a couple of files, my status screen looks like the one below. Note that these colours Continue reading →

The Ruby Rogues Podcast Review

The Ruby Rogues podcast purports to cover the Ruby programming language but once you start listening, you realize that there’s a lot more to this show than just Ruby. This is what makes the show appealing to people who are not Ruby coders. Typical shows include four to five hosts and occasionally a guest invitee. The show has a professional recording setup so the sound quality of the episodes is excellent.  Topics in the past have included how to become a better developer, testing, technical debt, Continue reading →

ANSI SQL to Retrieve the First n Rows

Now that we know how to retrieve the n-th row from a table, let’s use ANSI SQL to retrieve the first n rows from  table. The SQL should run on any ANSI SQL compliant database. Let’s go back and have a look at Figure 1 from my previous article. By making a small change to the query from my previous article, we can easily retrieve the first n-rows from a table. Example ANSI SQL to Retrieve the n-th Row -- Select the 500th row sorted Continue reading →