Re: A good Database Alternative to Access & SqlServer Express?
- From: Moty Michaely <Moty.Mi@xxxxxxxxx>
- Date: 13 May 2007 11:11:59 -0700
On May 13, 8:54 pm, "Larry Smith" <no_spam@xxxxxxxxxxx> wrote:
I am getting ready to write a shareware app in .Net using C# (actually
convert a VB shareware). I currently use a third party dll for the
data management. It is called the Tsunami Record Manager. I know that
it will not work in C# so I am looking for a very light-weight
database system that will work well in C#. I really don't want to use
Access if I can help it and Sql Server Express is really overkill.
Does anyone have any suggestions?
What does "light-weight" mean here. Due to the nature of RDBMSs and what
they offer, I think you'll find any mainstream DB package sufficiently
weighted-down so that it's potentially unsuitable for your needs (depending
on what they are of course). If you do find something that's apparently
satisfactory, you'll also have to consider its dependablity as well. Is it
stable and reliable. Free or public domain packages are also potentially
risky simply because their backers might not be around in a couple of years
(and they could be operating out of the back of a truck for all you know).
What about just using a simple "DataSet" as-is. I'm doing exactly that for
my own app and it's perfectly fine. There are no fancy bells and whistles
such as transaction support but you get a fairly decent DB engine already
built-in for free. For projects with minimal DB requirements it works very
well and costs nothing.
Larry, You are absolutely right, he should take all these into
account.
About public domain applications: I am not sure they are not more
stable than any other products. It's true that their originators will
probably not be there in the future.
But it doesn't mean anything about the quality of the product (See all
GNU license products).
Public domain or GNU products are very powerful, especially for free
ware applications. We should take them into account.
I didn't mention SQL Server Compact since I recall it was restricted
to Windows Mobile platforms only. Now it's not anymore.
Therefor, I think Mark is right. for the purpose of compact, .NET
based applications, SQL Server compact is the best solution.
"SQL Server Compact is a free, easy-to-use, lightweight, and
embeddable version of SQL Server 2005 for developing desktop and
mobile applications."
I think that's the best choice for you, Noble. just as Mark directed.
.
- Follow-Ups:
- References:
- A good Database Alternative to Access & SqlServer Express?
- From: Noble
- Re: A good Database Alternative to Access & SqlServer Express?
- From: Larry Smith
- A good Database Alternative to Access & SqlServer Express?
- Prev by Date: Re: Class to update db-structure
- Next by Date: software testing and performace tools
- Previous by thread: Re: A good Database Alternative to Access & SqlServer Express?
- Next by thread: Re: A good Database Alternative to Access & SqlServer Express?
- Index(es):
Relevant Pages
|
