1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Which is better MS Access, My SQL or Oracle?

Discussion in 'Databases' started by esignmatrix, Apr 14, 2010.

  1. graspit

    graspit Peon

    Messages:
    87
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #21
    I prefer MySQL because it is widely used.
     
    graspit, Jun 9, 2010 IP
  2. iimmdeepak

    iimmdeepak Peon

    Messages:
    208
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #22
    i think oracle is the best data base if u can work on it u can work on any other data base ,
    ms access is for the just small data bases with no security but oracle offers highest level of security.
     
    iimmdeepak, Jun 10, 2010 IP
  3. sketchx

    sketchx Member

    Messages:
    97
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #23
    Mysql :Rocks!!

    ORACLE : Its mostly a question of opinion for Oracle :), but its ok for companies that have deep pockets....oh yeah and alot of ressources...

    MS Access : too many limitations you can run into....its ok for "small" stand alone applications....
     
    sketchx, Jun 10, 2010 IP
  4. ashu_sood08

    ashu_sood08 Peon

    Messages:
    125
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #24
    each database used for storing the data but what we use it depend on the application for which you want to use the database the my sql is mostly used with the php programming as the backend the ms access is the first step to learn about the database but the oracle is the oracle and it perform all the queries and provide some extra function which we have not used in the sql the sql all queries run on the oracle but some oracle function is not run with the sql like settime function,setline etc the oracle is used in the big organization
     
    ashu_sood08, Jun 10, 2010 IP
  5. mahesh2011

    mahesh2011 Peon

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #25
    ms-access is only for a small project....who likes in the excel format ....my sql is a database which helps for a large storage of backup ....but usually companies uses oracle as a back end for their projects which survive a long last...
    ms-sql and asp.net will be helpful in doing a good project because both are microsoft product ..which is easy to maintain and implement ...
    php scripts and my sql act as a frontend & back end for major web developing projects.....php is the powerful technique,which is 20 times faster than other technologies
     
    mahesh2011, Jun 16, 2010 IP
  6. forum_scripteen

    forum_scripteen Guest

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #26
    MySQL to be the best for any web applications.
     
    forum_scripteen, Jun 18, 2010 IP
  7. leiraWebtrader

    leiraWebtrader Peon

    Messages:
    38
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #27
    I would prefer to use mysql for my website databases because oracle is a paid one
     
    leiraWebtrader, Jun 18, 2010 IP
  8. jyotesh

    jyotesh Peon

    Messages:
    55
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #28
    ms exel is d best. . mah vote goes 4 it. . .
     
    jyotesh, Jun 18, 2010 IP
  9. trustedfire9

    trustedfire9 Active Member

    Messages:
    57
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    58
    #29
    i prefer oracle , oracle secure for sql injection attack .
     
    trustedfire9, Jun 23, 2010 IP
  10. QuackWare

    QuackWare Member

    Messages:
    245
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    35
    #30
    I prefer MSSQL over mysql due to the support it has for the .net language. However I still use mysql from time to time.
     
    QuackWare, Jun 23, 2010 IP
  11. rachel.anthony12

    rachel.anthony12 Peon

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #31
    Using MS Access is much more simpler n easier compare to the other two for VB application while other tool which you can use is My SQL for bigger project as its a open source database.
     
    rachel.anthony12, Jun 24, 2010 IP
  12. Skuvnar

    Skuvnar Peon

    Messages:
    32
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #32
    it really depends on what you want to do.
    Use Access if you just want a simple/ no thrills database, MySQL if you are getting serious, but want to remain open source, and Oracle if you want a complete enterprise solution -eg data mining/ warehouses, auditing, etc.
     
    Skuvnar, Jun 24, 2010 IP
  13. Skuvnar

    Skuvnar Peon

    Messages:
    32
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #33
    Also I might there are other DB alternatives such as SQL server, PostGres, etc
     
    Skuvnar, Jun 24, 2010 IP
  14. blackemerald

    blackemerald Member

    Messages:
    86
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #34
    it depends on yours.
    If you want free one, you can use mysql.
    oracle and MS access is used for comercial but you can ask for help with their technical support.
    Whatever database you use, I think it better learn the sql language first.
     
    blackemerald, Jun 24, 2010 IP
  15. SportsBettingScholars

    SportsBettingScholars Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #35
    MySQL
    a) available free
    b) as good as identical on PC as on webserver ( therefore just one learning curve )
    c) widely used and plenty documentation and support available
     
    SportsBettingScholars, Jun 30, 2010 IP
  16. rupeshets

    rupeshets Peon

    Messages:
    130
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #36
    Oracle is best database.
     
    rupeshets, Jul 2, 2010 IP
  17. keerti

    keerti Greenhorn

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #37
    if u go with Appche My SQL with PHP is best combination ..As they are open source.
     
    keerti, Jul 6, 2010 IP
  18. NQhost

    NQhost Member

    Messages:
    141
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    45
    #38
    It's simple :)
    MS Access is more for office/application use.
    MySQL is best open source DB.
    Oracle is best commercial DB.
     
    NQhost, Jul 16, 2010 IP
  19. xtrecoolx

    xtrecoolx Greenhorn

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #39
    Obviously, Oracle is the best database :)
     
    xtrecoolx, Jul 16, 2010 IP
  20. seo.raj

    seo.raj Active Member

    Messages:
    273
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    71
    #40
    Basically, It depend on you and your plannings. If you are develop web site in Dot net frame work then i'll prefer My SQL. Because it is to maintain and Microsoft provide better connectivity. If develop in VB.net or D2k then i'll prefer Oracle.
     
    seo.raj, Jul 22, 2010 IP