babun - the best Unix shell for Windows

 

Sometimes the best way to use a computer is via its command line. This is particularly true for developers, there are times when even the best IDE wont' do. And its then that you realize that the best command line shell is the one on Unix. Window's command support is weak and an afterthought. In the on-premise model of enterprise software development, most companies use Unix or its variant for the production systems, due its much better stability, but also lower cost. There is nothing like grepping through entire log files to find culprit code in the system. cleartext.blogspot.com

The Unix/Linux shell has over 160 commands, and different distributions can have extra packages. This gives a developer on Unix limitless power on the commandline, using simple chaining, it is possible to solve the problem at hand without having to download any extra program. But things are bleak on the Windows front, where all you can do is dir and findstr. Sure the bat files have some more power, but there are still a lot missing.  I wondered if there was a way to get a working Unix like shell on the Windows system which can access the Windows filesystem but still do its magic. cleartext.blogspot.com

And I stumbled upon babun. If you are a developer like me, babun is the only shell you will need on Windows. It is a simple installable exe shell which accepts all unix commands, and then runs them on Windows. You don't have to set it up like cygwin. It does not even need administrator rights to install, and installs silently. After installation it creates a simple shortcut on the desktop, and runs a full xterm color interface.

And the shell understands  every standard Unix command, the usual grep, sort, wc,head , tail are all supported along with pipes. It periodically on startup, checks for updates. cleartext.blogspot.com

Installation of software on Unix is the biggest roadblock even today, and babun makes it easy to install anything easily. The installer is called pact.

But the best part is that it can access your native Windows disks, so you get the best of both worlds. cleartext.blogspot.com

So now you can have all your Unix power in Windows ! cleartext.blogspot.com

cleartext.blogspot.com

Excel turns 30 !

 

One of the most popular and widely used software utility, the backbone of countless projects ,graphs, and computations, turned 30. No, this is not about JAVA or any other programming language. I am talking of Microsoft's gift to the modern software engineer: MS Excel. According to Wikipedia, Microsoft released the first version of Excel for the Macintosh on September 30, 1985, and the first Windows version was 2.05 (to synchronize with the Macintosh version 2.2) in November 1987. The reason they released it first for Mac was due to the huge popularity of Lotus 123, the king of spreadsheets at that time. Gradually though, Excel has worked its way up and today is the default spreadsheet application of choice.

Its surprising that even the most die-hard fans of Excel do not know of this little bit of trivia, and Excel continues to be the downtrodden, faithful servant it has always been. Excel's history is really colorful, they started with copying off the features of Lotus 1-2-3, but then started adding features of their own, adding a mountain of functions to VBA, its automation script tool, and even changed the file format multiple times to incorporate new features. Today, it is even available on the cloud, and Google too has taken a few ideas for their Google sheets system. But what had set Excel apart is the Recalc feature, instead of re-computing the values of every formula cell, Excel smartly re-calculates only the values of cells required, nothing more. The original project team members reveal that this was done for optimization and speed, but only a handful of people knew the exact underlying workings.

My first tryst with Excel  was in circa 1993. We had to learn computer applications in school, and Lotus 1-2-3 was the software of choice, both in offices, as well as in school curriculums. I quickly figured out that Lotus 1-2-3 had this nifty macro system, which could be used to write quick and small functions to automate tasks. It was difficult to write the macro code, I remember one had to use the '=' key to access macro functions. But someone had installed MS Excel on the school machine assigned to me, and I found what I thought was the newer and improved version of Lotus. It had mouse support and had more colors for its graphs, and was faster. Way faster. It was fun to use, and easy to learn. Even in my wildest dreams, I could not foresee that this little piece of software would end up being the main part of my day-to-day work as a Software Engineer. I have built various tools during my work on Siebel and BIP using VBA macros, and maintain project information and even my loan and finance details on good ol Excel. Who would have thought that a simple idea of maintaining data in rows and columns would be the best way to start out any project.