473,394 Members | 1,739 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Database Compatibility

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?

Nov 21 '05 #1
3 1050
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/L...ink=sqlite.ppt

Ken
-----------------------------
"Dave" <da*******@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.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?
Nov 21 '05 #2
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" <da*******@gmail.com> schreef in bericht
news:11**********************@z14g2000cwz.googlegr oups.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?

Nov 21 '05 #3
"m.posseth" <po*****@planet.nl> wrote in
news:42**********************@nova.planet.nl:
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/
Nov 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: democratix | last post by:
Hi, I've only got a couple years experience developing for Access but have recently been experimenting with HTML/javascript for gui and client-side scripting, mysql for database and php for...
6
by: someone | last post by:
Suppose that I have a class in an assembly that is delivered to the user, what can I do to change the class so that it doesn't break the binary compatibility? That is, user application can run...
62
by: SAN3141 | last post by:
There doesn't seem to be consensus about when to put code in the database or in the middle tier. There was a long discussion about this in an Oracle newsgroup (message ID:...
0
by: Fernando Nasser | last post by:
Multiple database services and multiple versions on Red Hat Linux systems The way it works is that we require a specific service script for each database service (that is listening on each port)....
14
by: frostalicious | last post by:
Used VB.NET (on my client PC) to convert VB6 executable to .NET executable. Placed the .exe file on a network drive on my server. From client, ran .NET Wizards "Trust an Assembly" to make the...
3
by: paulh | last post by:
Hello, we are preparing for an upgrade to SQL 2005 and as a result of this I became aware that the compatibility level of one of our databases was set to level 65 (current SQL server is SQL 2000...
7
by: MLH | last post by:
I use this line DoCmd.SelectObject acTable, "tblAdmin", True when I want to display database window. Often- times, working on a remote mde via a TCP/IP connection, its convenient to have a...
13
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine...
2
by: Carlo | last post by:
I recently started in a new position, and I inherited an application written in VB6 that uses a bunch of DLLs and OCX controls. Version Compatibility is set to Binary at the project level, but since...
11
by: JB | last post by:
I'm writing a data driven app, its all just about finished but i havent decided how to store the data. I'm looking at some form of database. Requirements: Easy to Distribute, hopefully just some...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.