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]]

Re: Database Compatibility

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/LinkClick.aspx?tabid=36&table=Documents&field=ItemID&id=34&link=sqlite.ppt

Ken
-----------------------------
"Dave" <davesauny@gmai l.com> wrote in message
news:1123054821 .527749.192930@ z14g2000cwz.goo glegroups.com.. .
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]

Re: Database Compatibility

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]



"Dave" <davesauny@gmai l.com> schreef in bericht
news:1123054821 .527749.192930@ z14g2000cwz.goo glegroups.com.. .[color=blue]
> 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?
>[/color]

[Chad Z. Hower aka Kudzu]

Re: Database Compatibility

"m.posseth" <posseth@planet .nl> wrote in
news:42f0e9ef$0 $1568$ba620dc5@ nova.planet.nl:[color=blue]
> 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[/color]

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/
"Programmin g is an art form that fights back"

Empower ASP.NET with IntraWeb

http://www.atozed.com/IntraWeb/