Following are the listing of tools that can be used for various purposes in Linux, Windows environments and those which are available FREE of cost for downloads. This is the first compilation and will continue to grow as time progresses. (more…)

Is MySQL Case-Sensitive? The SQL syntax is NOT case-sensitive in MySQL. If the application written in PHP/Perl or other languages were to be used in Microsoft & Linux environment, then it would really be an issue for the database administrators and for the programmers. That is the reason why you might have noticed books or sites saying that it is always recommended to treat MySQL syntax as being case-sensitive. It was interesting to learn that the database name remains case sensitive.

A programmer may face acute conditions when working on PHP/MySQL on windows platform where he/she needs to configure certain settings or fine tune parameters or set permissions which involve usage of unix commands. For e.g. if you had a chance working with CakePHP framework or configuring it on windows, you might have come across this situation. Now, Windows users have the possibility to run unix commands by installing a command-line interface (CLI) such as Cygwin (http://www.cygwin.com) or MinGW (http://www.mingw.org) to lauch the CLI on windows environment.