What Database Do You Prefer?

So, what database do you prefer, which is better? What`s your favourite? Actually i need some tips about that, because i just need to know as much as i can about it So please, couldn`t you tell me what`s the best one, it`s advantages and diadvanteges, wich is easier to use and so on

Edited February 7, 2006 by miCRoSCoPiC^eaRthLinG (see edit history)

Hi, Divya,Two things :1) There are a lot of posts already asking this question, be careful to read them first, else some moderators here will tell you that you are spamming instad of asking precise questions. 2) There is no "best" database engine. However, probably, there is a very precise engine which is exacly meeting your needs. However, we should know your needs.- If you need a free database engine on a system you didn'b buy yet, using mysql on Xisto is the best choice.- If you already have a hardware Unix or Linux machine and want to learn something about databases and want a very powerful AND free dbms, mysql is still the best choice.- if you have a fully professional need, with several thousands of gygabytes live data, and thousands of simultaneous users on a very powerful Unix computer, Oracle is the best choice for the moment (and unfortunately almost the most expensive).Hope this helpedYordan

According to my engineering course,till now,my choice is Oracle 9i.

A RDBMS satisfies more than 6 Codd's rules.
Oracle 9i is simply a good choice with latest features.
And it is a good RDBMS.

If you know PL/SQL you can work in any RDBMS coz this is the common language for any database.
You may start learning with Oracle product first.
Later you may try SQL server 2000 i.e. Microsoft's product.
MySQL is also being very popular in these days.

good wishes.

Cinthia.

So, what database do you prefer, which is better? What`s your favourite? Actually i need some tips about that, because i just need to know as much as i can about it So please, couldn`t you tell me what`s the best one, it`s advantages and diadvanteges, wich is easier to use and so on

Edited February 13, 2006 by cinthia (see edit history)

my choice is Oracle 9i.

I almost agree. Personnally, I would choose Oracle 10g. If you startup using a RDBMS, you should use the current version, which is Oracle 10g, and not the previous one, which is Oracle 9i.Because if you put your site un production, you will want to have it running and being supported during at least three or five years, so you should not startup with a version which is already one year old.
Regards
Yordan

I prefer MySQL it is almost identical to SQL but with a few changes (improvements).

 

To start learning SQL, I suggest you go to the following address:

http://www.w3schools.com/sql/default.asp

 

To download MySQL, Apache, PHP, phpMyAdmin, etc, I suggest you go to the following address:

http://forums.xisto.com/no_longer_exists/

I am using MySQL and it is enough for me, it offers all I need and it is one of the most popular databases, I know Oracle is more advanced, but most of the hosts, especially free ones does not offer it. SQL is easy to learn, it is like sentences, the sql query's I mean. Most of the Databases will offer what you want.

SQL is easy to learn, it is like sentences, the sql query's I mean.

Yes, it's easy to learn. Do you know why ?
Do you know what SQL means ? It means Simple Query Language ! And it has been designed in order to be very close to the (English) natural language !

I suppose it depend on what script you want to run. I preffer mySQL becuase mose of the small scripts I know (and use) won't run on other databases.

That's the problem with such "universal" languages, they are "standard" and are supposed to work everywhere.In sql you have to write (select from blah where blah...), unfortunately they are some local details inside the "blah" which will make it work correctly with oracle and not with mysql... Of course, a guy knowing both will have no problems porting from one system to another one.Personally, just for fun, I tried converting the Oracle demo sql scripts on a postgresql, it never worked...

I like using MySQL for my own development while on Linux. Just real easy to use. However Corporate America is in love with Oracle and more or less DB2. I want to start using those just to be familar with it.I have aspirations to possibly be doing database administration or database software development. I have no problems managing a database, tweaking it up, backing up, all that stuff DBAs have to worry about. But I think the software development with a database backbone would be more for me. I did that before at a job I worked at as a co-op, it was fun stuff. I learned so much stuff there.

for me if hosting forum and web i'll be using mysql, cause it is free that's all. ms sql not bad but cost alot. oracle not need to said it cost a bomb and slow on any server except sun server

I want to start using those just to be familar with it.

You can learn Oracle on your home computer : Oracle lets you donwload Oracle in order to learn how to use it. Of course, when you finish learning, you must remove it from your computer ; don't put something into production without paying your licence.
Learning db2 is less easy, you cannot download a free licence, you have to ask to IBM.

except sun server

and except on AIX servers. Oracle on AIX is nowadays the fastest RDBMS in the world with the TPC benchmark.

For most webbased Content Management systems, I like MySQL mainly because it is the most widely supported database. Forums are a toss up with PostgreSQL usually edging out. MySQL was build around doing fast select quries and does that extremely well at the expense of some higher level features. Now MySQL has those higher level features, but raw performance is a little less. Conversely PostgreSQL has gotten faster over the years and has all the bells and whistles you'll find on more advanced DBS's such as Oracle or DB2. For a corporate level: you use what database your accounting software is designed for, end of story.

I prefer MySQL, it's so easy, it's a good performance, so fast to insert and get data into and from, but i heared that PostgreSQL is more lighter, i didn't try it in fact, i think i will try it once i need a light database, MySQL is so enough for me at the moment.p.s: i'm coding a financial application now using PHP/MySQL which is a Portfolio Manager.