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 ftp://ftp.postgresql.org/pub/source/v8.3.1/postgresql-8.3.1.tar.gz 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 […]

Read More Start using PostgreSQL now….

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 […]

Read More Sybase iSQL ASE 12.5 drive

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 […]

Read More Ruby Rocks 🙂

MYSQL replication in the same box


MYSQL replication in the same box   MYSQL 5.0.17 standard (SLAVE) – 10.0.0.1 MYSQL 4.1.1 standard (MASTER) – 10.0.0.2 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 = […]

Read More MYSQL replication in the same box