i recently got a client, he wants to have site for his company and also a personal site. (2 sites)

he is not sure which database to use.
and to be honest neither me..

i do not know which to choose, and which will be good for what purpose.

we have decided on using any one of these

oracle, Mssql, mysql, postgresql, db2.

now where do i find out which is good for which use?

so far i have used only mssql and mysql. and i do not much abt the other three.

so any help on this will be helpful and appreciated.


thanks in advance.

Chosing a database can be difficult and really depends on the scale of the database, what you want to do with it, and exisiting software.

Personally, for most applications I would use MySQL, because it is very powerful and easy to use (and widly supported). Postgresql is good when speed is required as it is very inefficient.

Oracle is excellent for very large databases. Its also popular in 'mission critical' type situtations.

Of course, if any database is already in use by the company (e.g. many use Oracle internally), I'd go with that.