Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

database: how to choose?

We are using the MS SQL database to store some of our more complex data.

Now we have the need for a smaller (and cheap) database, but not as small as Access, something that allows multiple tables, queries, multi users, we do not care about stored procedures and views. Size is not a big issue, we are talking about of tens of thousands records, but speed is a requirement. We were thinking about mySQL but we saw that requires a year distribution fee (the database will be distribuited with our applications, but it will be transparent to the user)

So my question is: where can I find information about which databases are available in the market, and how to compare them? So far I tried google, but I get only zero or a gazillion hits.

Many thanks in advance
Marco
[796 byte] By [mstraf] at [2007-11-11 6:47:39]
# 1 Re: database: how to choose?
Not sure how many concurrent users you are looking to support but have you considered MSDE or are you trying to get away from MS products?
pclement at 2007-11-11 23:48:09 >
# 2 Re: database: how to choose?
Thanks Paul, I appreciate
Not more than maybe three-five users?
I will look into MSDE, as you can see I am completely ignorant about this issue!
Marco
mstraf at 2007-11-11 23:49:09 >
# 3 Re: database: how to choose?
Three to five concurrent users is no problem for MSDE. BTW, MSDE is essentially SQL Server Jr. most likely to be replaced by SQL Server Express (released in November).

There is no administration tool for MSDE but there are front ends available (one of which I believe is free).

An alternative I would also recommend is VistaDB (http://www.vistadb.net/).
pclement at 2007-11-11 23:50:02 >
# 4 Re: database: how to choose?
Well, it looks like we have to support up to twenty concurrent users, in a network. That pushes up back in the kingdom of database servers, I guess. We are currently investigating mySQL and postGreSQL.
Thanks for your input.
Marco
mstraf at 2007-11-11 23:51:07 >