Database Compatibility

[Dave]

Ok here's the problem.

I am developing a piece of software to be used to create files which
can be sent to an embedded resource.

I want to store these files in a database as i need to create a
complete audit trail for each and every file created. The embedded
resource will also have a database stored on it to save any data
created on it which my VB.NET application must also be able to access
the embedded database.

This leads me to a simple problem.... are there any database
technologies that can be used in both VB.NET or C# and in embedded C?!?
Preferably the technology has to be free. If there arent any database
technologies available. How would I go about writing my own database?
How are databases stored in the files? I know about B-Tree Indexing so
that isn't a problem, it is just the saving the structure and content
of the database to a file that is a problem.

Anyone out there that can help?

 

[Ken Tucker [MVP]]

Hi,

Check out SQLite. I have not tried it personally but here is a
link to the presentation they did on it at a orlando .net user group
meeting.

http://www.onetug.org/admin/Portal/...=Documents&field=ItemID&id=34&link=sqlite.ppt

Ken
-----------------------------
Ok here's the problem.

I am developing a piece of software to be used to create files which
can be sent to an embedded resource.

I want to store these files in a database as i need to create a
complete audit trail for each and every file created. The embedded
resource will also have a database stored on it to save any data
created on it which my VB.NET application must also be able to access
the embedded database.

This leads me to a simple problem.... are there any database
technologies that can be used in both VB.NET or C# and in embedded C?!?
Preferably the technology has to be free. If there arent any database
technologies available. How would I go about writing my own database?
How are databases stored in the files? I know about B-Tree Indexing so
that isn't a problem, it is just the saving the structure and content
of the database to a file that is a problem.

Anyone out there that can help?

 

[m.posseth]

for a really great free database,,, firebird ,,,,, there is a reall RDMS
version and a embedded version wich can be scaled out easily to the rdms
version
als both versions are xcopy deployable have a small footprint ,,,,, the
server has a installation size of +_ 5 mb

http://firebird.sourceforge.net/

regards

Michel Posseth [MCP]

 

[Chad Z. Hower aka Kudzu]

for a really great free database,,, firebird ,,,,, there is a reall
RDMS version and a embedded version wich can be scaled out easily to
the rdms version
als both versions are xcopy deployable have a small footprint ,,,,,
the server has a installation size of +_ 5 mb

Firebird gets my vote too. We use it in several mission critical applications. The US Army uses
Interbase (IB is the original code base for Firebird) for several mission critical systems as well,
IIRC in one of the tanks.


--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Empower ASP.NET with IntraWeb
http://www.atozed.com/IntraWeb/