Good Database Query

Discussion in 'MySQL' started by orders211, Jan 28, 2008.

  1. #1
    Hi,

    I want to know Which one is the best database SQL or Oracle. Please Help
     
    orders211, Jan 28, 2008 IP
  2. CreativeClans

    CreativeClans Peon

    Messages:
    128
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    SQL is no database, it's a language. MySQL is a database.
    And it depends on your needs (and financial situation) whether the one or the other is better.
     
    CreativeClans, Jan 28, 2008 IP
  3. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Think they meant MS SQL Server.... they are more different than better or worse.
     
    AstarothSolutions, Jan 28, 2008 IP
  4. adams2on

    adams2on Peon

    Messages:
    30
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I've used both and would say Oracle is better for really big systems - and I believe more secure and robust. SQL Server has a GU Interface, so it is easier to set up a new DB in and also to administer, but the DB itself is not as powerful. The difference in power mainly only shows up when you get into huge systems. For programming, Oracle is easier to create stored procedures (that work within the DB so you save lots of time and resources by pushing the maximum of processing inside it) in - because Oracle has a full-fledged programming language for its stored procedures, whereas SQL Server has a much simpler (and for me frustrating after I got used to Oracle's) language and development tools, as well as debugging facility. Then there is MySQL with (I think) some GUI tools from third parties to manage it. The DB itself is far cheaper than either Oracle or SQL Server, open source with low-cost commercial license and free for personal or (maybe?) nonprofit or educational use (check those facts if it matters). Hope this helps! :)

    Bruce
     
    adams2on, Jan 29, 2008 IP
  5. jayasimha

    jayasimha Peon

    Messages:
    48
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Hi,

    Postgres serves me well.

    cheers,
    jay
     
    jayasimha, Jan 29, 2008 IP