Fog Creek Software
Discussion Board




Where can I buy a cheap version of SQL Server

I am looking to buy a cheap version of SQL Server. DOes anyone know of anywhere?

Sonia
Wednesday, November 06, 2002

A "lite" version of SQLServer is MSDE.  You can get it here http://www.asp.net/msde/default.aspx for free.  Can't get much cheaper that that <g>.

Wayne
Wednesday, November 06, 2002

Do you mean SQL Server, as in the MS product, or a Relational database in general?

If it's the MS version, then yeah, MSDE is your best bet, although it is intentionally crippled to not handle very many users.

You might want to look into MySQL. It's a fantastic Open Source Relational database. It's free, quite powerful and runs on Linux and Windows.

Mark Hoffman
Wednesday, November 06, 2002

MySQL might be cool for backing a website, but it does not support relational integrity, stored procedures, triggers and a whole bunch of other things that you get out of the box with SQL Server

Crusty Admin
Wednesday, November 06, 2002

I don't know why everyone keeps saying that mySQL is the ultimate Open-Source database. As Crusty said - it's good for a website or any other application that's mainly data retrieval but it's seriously lacking in other areas.

Look at PostgreSQL http://www.postgresql.org/ or SAP DB http://www.sapdb.org/ if you want an Open-Source database with real ACID properties.

jeff
Wednesday, November 06, 2002

Jeff, to piggy back on what you said.  Phil Greenspun wrote a nice article about what is important in a dbms, this is a link to another article that references Phil's article.  Though slightly outdated, alot of these are still problems. 

http://openacs.org/philosophy/why-not-mysql.html

crusty admin
Wednesday, November 06, 2002

"I don't know why everyone keeps saying that mySQL is the ultimate Open-Source database. "

Hmm..I don't recall anyone saying it was the ultimate, but it is arguably the world's most popular open source DB.

It may have its warts, but it has proven itself to be remarkably stable and efficient. I recently read an article about how the makers of "Dark Age of Camelot" laughed at Oracle when they wanted nearly a million for the database.  After they recovered from the sticker shock, they implemented mySQL on Linux and they were off and running. I don't play DAOC, but I know that they have thousands of simultaneous players that are constantly hitting the DB.

Of course, the argument is academic to me. MS SQL Server isn't really that expensive for casual use.

Mark Hoffman
Wednesday, November 06, 2002

Can you get the URL of the article, as I play the game I would like to know how it works.

STephen Moody
Thursday, November 07, 2002

Stephen,

Go to www.gamasutra.com and do a search for mySQL and camelot. You will see the post-mortem article for DAOC.

You will need to register with gamasutra first, though. But it's a very interesting article, particularly if you are into the MMORPG scene.

Mark Hoffman
Thursday, November 07, 2002

Mark,

Thanks for that, I can't get to it at work ast the bloody proxy server has clasified the site as games. But I will look at it when I get home.

Stephen Moody
Thursday, November 07, 2002

*  Recent Topics

*  Fog Creek Home