Database Options

[Guest]

I am looking for some assistance in choosing a database. I am working on a
network management appliction. I need to have a database that will hold a
moderate amount of data on the users pc. I have a few requirements:

1. Easy to set up (hopefully no setup required by the user beyond the
normal install process for the application)

2. Multithreading. The database will be accessed from several threads in
the application. I have used access in the past and got around it by locking
the database each time I call it but I don't care for that alternative.

3. Free for the user. The user shouldn't have to purchase the database
seperately or buy seats.

The previous version of our product used SQLite and I was wholey unimpressed
by it. Thanks for your advice.

 

[Nicholas Paldino [.NET/C# MVP]]

Eric,

You might want to take a look at SQL Express 2005. It is free, and the
install should be able to be wrapped up into your regular install (it is an
MSI).

Also, you don't have to worry about locking access to it, since the
server will handle it (it is a server, after all).

Hope this helps.