Kurinchi Blogger Scribbles …


Archive for December, 2008

Dec 31
2008

MySQL vs. PostgreSQL – Comparison

Last updated: December 31st, 2008

There had often been talks and some times flame wars when there had been comparison between MySQL and PostgreSQL. Each database has its own strength and weaknesses. As an initiative, I thought to do a little research on this topic and to list down the common points gathered in a tabular format. (more…)

Dec 31
2008

Setup cakePHP framework – stable version 1.2.0.7962 released

Last updated: December 31st, 2008

CakePHP commonly known as ‘Cake’ is easy to install and faster to configure. It needs Apache (with mod_rewrite enabled), Php 4.3.2 or higher, MySQL/PostgreSQL/other ODBC, ADODB compliant databases.

XAMPP by ApacheFriends or MAMP has a complete installation of the above products which is an ultimate time saver. But, you should prefer installing each software individually in order to get a grip on the subject.

You can download the latest release from http://cakeforge.org/frs/download.php/695/1.2.0.7962.tar.gz (more…)

Dec 30
2008

How to run Unix commands in windows?

Last updated: December 30th, 2008

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.

Dec 29
2008

MySQL database optimisation series – Right MySQL Data type

Last updated: December 29th, 2008

Numeric Data type in MySQL

Choosing the right data type can create significant improvement in application performance.

Many programmers/developers who opt to choose MySQL as the backend for their operations often fail miserably in choosing the most efficient data types. (more…)

Dec 24
2008

phpMyAdmin – visual interface for MySQL on Windows/Linux

Last updated: April 14th, 2009

phpMyAdmin is a web based interface to MySQL which is written using PHP for Administration of databases. Visual interface provided is intuitive and it saves time for the developers. (ver 3.1.1 is the recommended version as of this writing which runs on PHP 5/MySQL 5)

Step 1: First we need to check MySQL is installed by issuing the following command
[root@user Desktop]# which mysql

If you get …
/usr/bin/mysql
then, it is an indication that MySQL is installed in your machine. (more…)

Dec 24
2008

Apache Server – Where to set folders, files for hosting applications?

Last updated: December 24th, 2008

There will be a link in httpd.conf file stating the document root where all our web application files need to reside though there can be symbolic links pointing to other locations.

[root@user Desktop]# vi /etc/httpd/conf/httpd.conf
……….
……….
DocumenRoot “/var/www/html”
……….
……….

Based on the configuration setting, we need to identify the location where we need to create folders that will serve as the root for the applications that we would want to host.

Dec 24
2008

Apache server installation on CentOS, RedHat Linux

Last updated: December 24th, 2008

Apache web server referred to as simply Apache is a public-domain open source Web server developed by open community of developers. The application is designed to run on a wide variety of operating systems like Unix, FreeBSD, Linux, Mac OS X, OS/2. Visit http://www.apache.org for more details.

In your terminal, issue the following command (by default, httpd is installed). This will install apache if it was not installed. (more…)

Dec 11
2008

Subversion installation steps – Part 1 (Client installation)

Last updated: December 11th, 2008

subversionSubversion is a version control system software that is used for effective and efficient quality management of projects consisting of any number of files. It is a substantial alternative to CVS repository and has gained popularity in very short time. Subversion is used in many companies ranging from small/medium scale companies to large scale enterprises because of its ease of use compared to other available products in the market. (more…)

Dec 11
2008

How to create shortcuts in Linux?

Last updated: December 11th, 2008

SciTE is one of the IDE’s available under Freeware category in the market for PHP/ASP/Ruby/++ scripting. I have used that as an example to answer the above question.

Once the software is downloaded and configured in your system, you might want to create a shortcut for that application in the desktop. Creating a symbolic link would help you in that.

[root@user Desktop]# ln -s /usr/local/bin/SciTE $HOME/Desktop/scite

i.e.

[root@user Desktop]# ln -s [path-to-executable-file] [TARGET-location-where-shortcut-is-to-be-created]

Dec 09
2008

.htaccess – gzip output content

Last updated: December 9th, 2008

GZIP compression is used for compressing the content of the web pages by the server before the content (text & images) get passed to the browser. The browser takes this input and decompresses the content before delivering it to site users.

Compressing the content of the pages makes the page size small which in turn will have a positive & significant impact on the page loading. There is a misconception that the larger bandwidth availability or lesser file size is what is needed for faster page loading, which is not. (more…)


Valid HTML 4.01 Strict  Valid HTML 4.01 Strict