Free or inexpensive database solution?

Discussion in 'OT Technology' started by Cranky, May 27, 2003.

  1. Cranky

    Cranky New Member

    Joined:
    Jun 27, 2002
    Messages:
    2,209
    Likes Received:
    0
    Location:
    Las Colinas, TX
    Im running a web server. I need a database solution that is either cheap or free. Im running windows 2000 with apache v2 and ftp serv-u. I have php installed. I wanted to run mysql but it is out of my budget. I can make text based databases with ASP cant I? Is ASP free?
     
  2. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    mysql out of your budget? It's free, unless you're trying to make a profit i believe?

    you can try MSDE which is basicly the free SQL Server engine. The install comes with Microsoft office i believe.
     
  3. Surgie

    Surgie Mein Führer, I can walk!

    Joined:
    Jun 24, 2001
    Messages:
    69,008
    Likes Received:
    0
    Location:
    Knoxville, TN
    What do you mean MySQL is out of your budget? Last time I checked (which was just a few months ago) it was still free (unless you couldn't use anything with the GPL) :confused:

    And most likely if it was a fairly small db you could get away with a flat text file, but its not going to be nearly as fast as a real database setup.
     
  4. Rob

    Rob OT Supporter

    Joined:
    Jul 6, 2002
    Messages:
    88,614
    Likes Received:
    36
    Location:
    Atlanta, GA
    As stated MySQL is free and open source. Give that a try unless liscensing issues trouble you. If that is the case then there aren't many good, free, powerful database servers I can think of.
     
  5. Kevin

    Kevin New Member

    Joined:
    Aug 27, 2002
    Messages:
    87,634
    Likes Received:
    0
    Location:
    Michigan
  6. Surgie

    Surgie Mein Führer, I can walk!

    Joined:
    Jun 24, 2001
    Messages:
    69,008
    Likes Received:
    0
    Location:
    Knoxville, TN
    PostgreSQL comes to mind, its under the BSD liscense as opposed to the GPL...
     
  7. CompiledMonkey

    CompiledMonkey New Member

    Joined:
    Oct 26, 2001
    Messages:
    8,528
    Likes Received:
    0
    Location:
    Richmond, VA
    If for whatever reason you can't use MySQL, you could always create XML "database" files.
     
  8. Rob

    Rob OT Supporter

    Joined:
    Jul 6, 2002
    Messages:
    88,614
    Likes Received:
    36
    Location:
    Atlanta, GA


    :doh: Forgot about that one. :big grin:
     
  9. Astro

    Astro Code Monkey

    Joined:
    Mar 18, 2000
    Messages:
    2,047
    Likes Received:
    0
    Location:
    Cleveland Ohio
    Unless you expect to have a few records, stay away from the ASCII text file approach (that includes XML). This approach yields really crappy scale ability. There will be a lot of overhead to process an ASCII file...

    Try:
    MySQL
    Postgres
    mSQL

    Out of your budget?? Try getting your money back on the W2k server and switch to Linux! :)
     
  10. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    personally i have had most success with MySql and php. they go hand in hand :)

    easy install on a 2k box, http://www.mysql.org
     
  11. Cranky

    Cranky New Member

    Joined:
    Jun 27, 2002
    Messages:
    2,209
    Likes Received:
    0
    Location:
    Las Colinas, TX
    I dunno why I over looked mysql being free... im stupid. im running apache mysql an php.
     
  12. Astro

    Astro Code Monkey

    Joined:
    Mar 18, 2000
    Messages:
    2,047
    Likes Received:
    0
    Location:
    Cleveland Ohio
    Excellent choice! The three of those work very well together (I manage 2 Linux boxes and 1 W2k box configured like this and no problems at all).
     

Share This Page