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…)
Archive for December, 2008
Dec
31
2008
Setup cakePHP framework – stable version 1.2.0.7962 released
Last updated: December 31st, 2008CakePHP 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, 2008A 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, 2008Numeric 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, 2009phpMyAdmin 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, 2008There 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, 2008Apache 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
Subversion 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, 2008SciTE 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, 2008GZIP 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…)
- How to check if linux server can send out email via command line?
- Reverse DNS and Junk Email
- Linux: How to upgrade PHP from 5.1 to 5.2 in CentOS5?
- SEO: Steps to take after submitting to search engines
- Linux: How to list or allow access to ports ?
- MySQL: ‘Access denied for user ‘root’@'localhost’ (using password: YES)’
- SEO: Steps to take before submitting
- MySQL: How to stop, start or restart mysql?
- Linux: Case sensitive MySQL table names
- Apache: [warn] NameVirtualHost *:80 has no VirtualHosts
-
.htaccess
Apache
Apache installation
Apache Server
asterisk
cakePHP
CentOS
CGI
command prompt
Configuration error
CSS
Fedora
Gunzip
http
httpd.conf
java
jQuery
LINUX
Linux Run Level
linux tricks
mplayer
my.cnf
MySql
Nagios
Operating System
Perl
PHP
php.ini
PHP error
phpMyAdmin
Run Level
search engine
search engine optimization
search engine tips
SELinux
SEO
shell scripting
ssl
subversion
svn
ubuntu
virtual hosting
windows
xml
zend
