MySQL/PostGreSQL/IBM DB2

Discussion in 'MySQL' started by Algore, Feb 15, 2008.

0
  1. #1
    MySQL/PostGreSQL/IBM DB2

    Which is the best among the 3 mentioned.

    I know something about PostGreSQL is the maximum database size is limited to 32 TB ( Terebyte ) which is more than enough even for world class companies .. even World Bank wont have a database of 32 TB

    IBM DB2 is outdated i hope i heard from someone. But its more powerful than the rest.

    Anyway can anyone please tell me the major differences
     
    Algore, Feb 15, 2008 IP
  2. gate2vn

    gate2vn Peon

    Messages:
    809
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    0
    #2
    I only use mySQL, so I am not really sure about others. But mySQL is very strong db back-end, and now, supported by SUN, that I would like to see some more stronger points soon
     
    gate2vn, Feb 15, 2008 IP
  3. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Not sure DB2 is outdated, the data warehouse version was only launched in 2006.

    It depends what you are wanting to do with the db, just as optimal db structure varies between warehousing and production systems so different db servers are better or worse in different circumstances.
     
    AstarothSolutions, Feb 16, 2008 IP
  4. dspohn23

    dspohn23 Peon

    Messages:
    370
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #4
    The reason some people think that DB2 is outdated, is because many companies are running old versions of DB2 on their old mainframes. However there are new versions of DB2 that are out there.

    I have the most experience in mySQL and MS SQL. If you are running a small to medium size website mySQL will work for you. If you have a very large website you may need to look into mySQL clusters or MS SQL. It all depends on what you are trying to do with it, and the load that you are putting on the server.
     
    dspohn23, Feb 16, 2008 IP
  5. Petey

    Petey Peon

    Messages:
    68
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Hi Algore,

    MySQL - A good, general purpose database. Version 5 is a vast improvement over version 4.

    PostgreSQL - Great if you need to write your own routines to store/retrieve from the database. Write your program in your favorite language, register it as a stored procedure and you are done.

    DB2 UDB - A good database with very powerful database admin tools.

    The best will depend on your needs. If database management is very important then DB2 is better than the others, if you need to write your own custom stored procedures then PostgreSQL may be best, if you just need a general purpose engine then MySQL is best for now.

    If SUN decide to make the licensing for MySQL more restrictive then PostGreSQL may become far more attractive.
     
    Petey, Feb 19, 2008 IP
  6. pondlife

    pondlife Peon

    Messages:
    898
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #6
    If you're building a website then I'd say MySQL - you'll probably find it on more hosts (Linux) and better supported. For me I like MySQL because of the wealth of information available on the web - and how it integrates with PHP. Also the phpMyAdmin web front-end is brilliant - most of your work can be done from here rather than the command line (which most hosts don't let you have unless you're on a dedicated server).

    For the long-term MySQL looks pretty good too because it's been bought-out by Sun - I think they're going to put some good money in it and make it a real commercial proposition which means that it will be a good skill to have on your CV.

    My two pennies :)
     
    pondlife, Feb 19, 2008 IP