Skip to content

March 5, 2007

3

Oracle / MySQL /MsSQL

Though the three major competitors in database world released their own free edition, MySQL is the only application that is open source . But recently, Its licensing GPLed was questioned by php and php removed its support for MySQL in its package. However, MySQL manage to get back to the situation.(Yahoo,Google Adwords… etc uses MySQL)

Oracle sees everything in the world having db as eyes. To jot down a point, first step is they will do is to create a table. Thats funny and also logical. As per my knowledge, its primay focus is promoting Java there by its Application server (OC4J). Oracle not only provides database for free, also its entire set of tools, Oracle Developer Suite also available free. (Most of the banks)

MsSQL Server, when everyone goes free, one cannot stay charging money for usage, Ms SQL Server is mostly used with microsoft related application.

Recently, Oracle takes leads the race with lots of acquisition and its features. Espescially, stored Procedures, packages and jobs, they introduced followed by others, to make it standard.

Another one sad note for a big company is they bring something new to pitch, but eventually there would be some standards committee would be formed which states the big company fails to comply with standard. Espescially, microsoft has experienced lots in this way. And so, they deserve it.

So you have got three free powerful Database, all for free. None is no lesser or worser than the other. Though my Favourite would be Oracle, I would be opting Mysql because of large number free web hosting service offering it..

Read more from Appz
3 Comments
  1. smart
    May 1 2007

    The advantages scrapped about OurSQL is just a count.

    1 – OurSQL is an Open Source , but follows GPLed vs Other Opensource application which use GPL license.. check out this link http://www.lamp2lapo.com/2006/11/07/php-conference-update-oracle-is-free-and-easy-to-use/

    2 – Oracle Database Xpress edition, Microsoft’s Sql Server – no cost for development

    3 – Everyone will copy the best.

    4 – All software updating with new facilities day by day.

    5 – For small application, I have come across with another opensource db called sqlite, thats the simply the best (basically flat file db with sql functionality)(entire installation takes 210kb.. amazing)

    6 – its basically, PL/SQL that is easy to learn which is common to all.

    7 – It was the only powerful opensource DB that stands against Oracle. But if competition exceeds by far, Microsoft/Oracle has to opensource their db as they have make it free but it wont happen as this free marketing earns more money than ordinary.

  2. smart
    May 1 2007

    Will Oracle Supports Codd’s Rule..??? Also MySQL has advantages in comparison to Oracle.

    1 – MySql is Open source, which can be available any time

    2 – MySql has no cost of development purpose.

    3 – MySql has most of features , which oracle provides

    4 – MySql day by day updating with new facilities.

    5 – Good for small application.

    6 – easy to learn and to become master.

    7 – MySql has a good power these days. Even Google , Yahoo , Amazon Uses this ….:)

    even though MySql having so many advantages, Oracle is best database ever in Software development. I accept ..

Comments are closed.