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
31
2008
Setup cakePHP framework – stable version 1.2.0.7962 released
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
30
2008
How to run Unix commands in windows?
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
29
2008
MySQL database optimisation series – Right MySQL Data type
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
24
2008
phpMyAdmin – visual interface for MySQL on Windows/Linux
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
24
2008
Apache Server – Where to set folders, files for hosting applications?
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
24
2008
Apache server installation on CentOS, RedHat Linux
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
11
2008
Subversion installation steps – Part 1 (Client installation)
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
11
2008
How to create shortcuts in Linux?
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
09
2008
.htaccess – gzip output content
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…)
Categories
Archives
StatPress
Visits today: 26534
Recent Posts
- PHP: ‘Fatal error: Allowed memory size of 8388608 bytes exhausted’
- Any Video Converter: Free Software
- FTP: 530 login authentication failed
- Beginner: Why there are many Linux Distributions?
- MySQL GUI tool for Data Management
- Asterisk for Beginner: IAX Server configuration settings
- Asterisk Error messages
- Unable to connect to remote asterisk (check if /var/run/asterisk/asterisk.ctl exist?)
- ASTERISK Configuration: for beginners
- How to move the SSL certificates?
Tags
-
.htaccess
Add new tag
Apache
Apache installation
Apache Server
asterisk
cakePHP
CentOS
CGI
command prompt
Configuration error
CSS
Fedora
Gunzip
httpd.conf
jQuery
LINUX
Linux Beginner
linux notes
Linux Run Level
Linux tips
linux tricks
mod_rewrite
mplayer
MySql
MySQL datatype
Nagios
OpenVPN
Operating System
Perl
PHP
php.ini
PHP error
phpMyAdmin
PostgreSQL
RedHat
Run Level
shell scripting
ssl
subversion
svn
ubuntu
virtual hosting
windows
xml
