>which database server should I use. MySQL or PostGRE SQL
>Rajesh

IMO, PostgreSQL is the better, more Oracle-like of the two. In fact, many of the packages (proc and funcs) uses as written in PostgreSQL. It has stored proceedures, triggers, packages, OOP (part or all of tables can be inherited in the definitions of new tables, with all that implies), and all the things that "ATOM" requires.

MySQL has a lighter footprint and is faster in smaller applications, but as the number of rows and/or tables increases their speed differences diminish and PostgreSQLs power and stability shine through. There are horror stories where folks start with MySQL on website databases, because of its lightness and speed, but get burned because it crashes too easy and doesn't scale well.

MySQL v 4.0 is supposed to have Transactional Tracking, but they have to redesign their animal from the hoofs up... It is a private project and the source is not available. PostgreSQL is Open Source and the source IS available.

I understand that Jason Nance, a UT member, makes a living installing Linux systems with MySQL and he limits his target client to situations where their total number of rows never exceeds 500,000.