Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Unanswered: Should i go for MS SQL server or MySQL or PostgreSQL (was "SQL newbie")

    I am using WIN XP and i am starting to learn SQL. Could someone please tell me what is that best to run my SQL commands.
    Should i go for MS SQL server or MySQL or PostgreSQL.
    Oracle is too big to run on my PC & difficult to get. So, pls tell something i can download for free.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Both MySQL and PostreSQL are free. The Developer Edition of Microsoft SQL is $50 US, but the Express Edition is free. You'll have to sort out what you want to use based on your needs, but I'd be inclined to recommend the Developer Edition for many reasons if you are looking to learn a marketable skill.

    -PatP

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Also Oracle Express is free.
    [/B]
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    last itme I heard you can also get a DB2 version for free. I think virtually all of the SQL server products have a free offering - must be getting scared that new users may get hooked on using MySQL or POSTGRES!
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jan 2006
    Posts
    27
    Unfortunately, all the db's mentioned have "enhancements" to the SQL specification that can very quickly make your SQL code db specific. There are 2 things to consider:

    1) Is this for a specific Project? Are you planning on building an particular application?

    2) Is this about the Database, and DBA routines, and Serverside SQL programming, or about getting data out of the DB.

    If it for a specific project, you need to consider the specs and eventual architecture.

    If it's about managing or programming a database, each db has SIGNIFICANT differences. Pick one or more and become proficient.

    If it's about gettting data in/out of a db, choose an access method (odbc/jdbc/.Net/oledb/DBI/etc.) to interface with, and choose any one you feel comfortable with, even MS Access. The more generic the access method, the less the backend DB matters.

    Jay Grubb
    Technical Consultant
    OpenLink Software
    Web: http://www.openlinksw.com:
    Product Weblogs:
    Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
    UDA: http://www.openlinksw.com/weblogs/uda
    Universal Data Access & Virtual Database Technology Providers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •