MySQL cleaner ways to do things

Create table ..

CREATE TABLE `mycash`.`unit` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Sequence number',
`name` VARCHAR(45) NOT NULL COMMENT 'organization or home name',
`type` ENUM('Home','Organization','Community') NOT NULL DEFAULT 'Home',
`country_code` TINYINT UNSIGNED NOT NULL,
`area_code` SMALLINT UNSIGNED NOT NULL,
`pincode` INTEGER UNSIGNED NOT NULL,
`street_address` TEXT,
`creation_date` DATE NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB
COMMENT = 'Top level entity, could be a house, organization or community';

Free Domain names, Free Java PHP MySQL hosting

The following free domain name registrars are in my knowledge

1. co.cc
2. freedomain.co.nr
3. dot.tk

If you are also looking for a hosting support free of cost PHP, Tomcat, MySQL, then you can comment on this article, I have a server at my home and I can arrange some space over that.

LAMP - Apache, PHP, MySQL Installation easy steps

Some like it binary some like compiling, I am amongst the compiling ones..
here are some easy steps that I usually follow to compile Apache, PHP to my machine.

1. Apache
1. ./configure --prefix=/usr/local/apache2.2.6 --enable-so --enable-proxy --enable-rewrite --enable-expires --enable-headers --enable-deflate --enable-ssl
2. sudo make
3. sudo make install
4. cd /usr/local
5. ln -s apache2.2.6 apache
6. cd
   
2. PHP
1. ./configure --prefix=/usr/local/php5.2.5 --with-mysql=/usr/local/mysql --with-apxs2=/usr/local/apache/bin/apxs --with-gd --with-jpeg-dir=/usr/lib --with-png-dir=/usr/lib
2. sudo make
3. sudo make install
4. cd /usr/local
5. ln -s php5.2.5 php
6. Configure Apache httpd.conf for PHP module
1. LoadModule php5_module modules/libphp5.so
   
2. AddType application/x-httpd-php .php .phtml
   

Ubuntu Server edition kernel compile make menuconfig error

I install Ubuntu 7.10 Server edition, it was nice required less resources. GUI was missing, but the resources it saved where more important than X11.
Then I wanted to install Ultra Monkey and for that I read that first kernel needs to be patched up. I downloaded the kernel source from kernel.org, unzipped it and tried "make menuconfig" to my surprise it gave error and it was hard to understand.
Googling made me land on the fact that it requires ncurses-devel
I tried "sudo apt-get install kernel-package libncurses5-dev fakeroot wget bzip2"
and then "make menuconfig", now things work...

Ubuntu 8 Download

Ubuntu 8 is about come, beta is scheduled to be released on 20th mar, meanwhile if cannot wait ( like me ) then things can be downloaded from here
One more thing that I discovered today that its not just Mythdora alone, there are Mythbuntu and KnoppMyth also in the market, however I must mention here that my experience with Mythdora was very bad neither I liked the OS nor did the MythTV worked as decently as I thought It would.

vi editor tips & tricks

To enable syntax hi lightening
:syntax enable

enable line number
:set number

Indentation
:set autoindent

you can make a file ~/.exrc with these commands so that every time vi starts you don't have to re enter the commands

my exrc contents are ..
------------------------------
:set number
:set autoindent
:syntax enable
------------------------------

url rewriting in java & php

A lot of time we need to re-write URLs from dynamic to static, the reason may be security or SEO, but we keep needing it from time to time
I had done the same in PHP applications that I had build using mod_rewrite ( a module that can be compiled under apache httpd). Recently I was asked to do the same with an application running on Tomcat server I found an easy way to do it.