Start using PostgreSQL now….

Spend 10 minutes and have PostgreSQL on your own lilo flavor Purpose of this article to give jump starts to install and performed basic PostgreSQL (pgsql) administrator / user job. Download binaries from this location tar -xzvf postgresql-8.3.1.tar.gz ./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su – postgres /usr/local/pgsql/bin/initdb […]

Sybase iSQL ASE 12.5 drive

This article will get you up and running with Sybase database commands. I personally refer it many times when I need  specific command. I kept it comprehensive reference material for anyone to jump start. What is difference between SQL & T-SQL? SQL- set of sqls are submitted individually to the database server. T-SQL- the batch […]

Ruby Rocks :)

Today I am going to share my very first experience with RubyOnRails, and to describe my feelings its fabulous. Lets begin What you need to know already? You should be familiar with any MVC pattern Should have knowledge of Ruby Should know DB & Web server fundamentals I guess thats more then enough to begin […]

MYSQL replication in the same box

MYSQL replication in the same box   MYSQL 5.0.17 standard (SLAVE) – MYSQL 4.1.1 standard (MASTER) – MASTER running on port 3306 SLAVE running on port 3308 MASTER (my.cnf) server-id = 1 log-bin SLAVE (my.cnf) [mysqld] server-id = 2 master-host = localhost master-user = root master-password = mysql master-port = 3306 replicate-do-db = […]