Embeddable databases

  • Thread starter Thread starter Gerrit
  • Start date Start date
G

Gerrit

Hi.

I'm looking for a relational and embeddable "file system based"
(non-client/server) database engine for .NET applications. Microsoft
JET (Access) is not an option, as it looks like it is being quietly
phased out without a replacement. So far I have found these three that
seem to be worth considering:

SQLite: http://www.sqlite.org
Firebird (embedded): http://www.dotnetfirebird.org
VistaDB: http://www.vistadb.net

Any comments or suggestions?


Gerrit
 
Gerrit said:
Hi.

I'm looking for a relational and embeddable "file system based"
(non-client/server) database engine for .NET applications. Microsoft
JET (Access) is not an option, as it looks like it is being quietly
phased out without a replacement. So far I have found these three that
seem to be worth considering:
SQLite: http://www.sqlite.org
Firebird (embedded): http://www.dotnetfirebird.org
VistaDB: http://www.vistadb.net
Click to expand...

Firebird's embedded server is OK, however some very complex queries
might fail. (8 joined tables or more). but then again, it's free and
works OK. Also an advantage: a lot of tools support firebird, and with
Carlos' excellent .NET provider for Firebird, you can develop against
the firebird server, and move your code to an embedded situation with
just a change in the connection string.

Frans

--
 
It looks like when using the embedded Firebird engine, only one user can
access the database file at the time. Do you know if this is true? Only one
user will write to the database, but it may happen that multiple users will
read from it at the same time (even though that is unlikely).

Gerrit
 
Gerrit said:
It looks like when using the embedded Firebird engine, only one user can
access the database file at the time. Do you know if this is true? Only
one user will write to the database, but it may happen that multiple
users will read from it at the same time (even though that is unlikely).
Click to expand...

that's not the purpose of an embedded db I think: the db in an embedded
app is there to support the app, which is ran by the user. If you have
multi-user requirements, I think a normal server database setup would be
more appropriate...

FB
Gerrit
Click to expand...


--
 
Firebird's embedded server is OK, however some very complex queries
might fail. (8 joined tables or more). but then again, it's free and
works OK. Also an advantage: a lot of tools support firebird, and with
Carlos' excellent .NET provider for Firebird, you can develop against
the firebird server, and move your code to an embedded situation with
just a change in the connection string.

Frans
Click to expand...

Frans,

Will the firebird provider work in the server explorer?

Otis Mukinfus
http://www.otismukinfus.com
 
Otis said:
Will the firebird provider work in the server explorer?
Click to expand...

I haven't tried these yet. The server explorer requires an OleDB driver
to work, but to get the visual designers to work you need more than that
(see the work Oracle is doing at the moment to get their support into
vs.net).

Frans

--
 
I agree, but the clients are only using the database as "read-only data
store". I was originally going to use a XML file, but I need something I can
perform some simple queries on without having to load the entire
database/dataset into memory. The database is only going to be updated once
a week or so, so there will be no concurrency conflicts or even concurrent
writes. Just simple quieries.

Gerrit
 
I haven't tried these yet. The server explorer requires an OleDB driver
to work, but to get the visual designers to work you need more than that
(see the work Oracle is doing at the moment to get their support into
vs.net).

Frans
Click to expand...

Thanks, Frans, but it's a moot question. No matter what I try I can't connect
via their ISQL tool, so I'll be uninstalling it.

Otis Mukinfus
http://www.otismukinfus.com
 
Back
Top