473,414 Members | 1,677 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,414 software developers and data experts.

Flat file database

I want to construct a simple flat file, non-relational database within my
windows application. It would be a simple table with fields contained in a
separate file which accompanies the distribution. It needs to be searchable.
I don't want to use MS Access or MSDE (SQL Server) in this application for a
few reasons. 1. It does not need to be relational. 2. The search will be
restricted to a single field of data, the results of which will set the
record pointer necessary to get the remaining information in the record. 3.
I want the maximum number of people to be able to use the application.

What are my options?

--
http://www.dennisys.com/
Nov 21 '05 #1
4 2634
> What are my options?

Thought about XML? Sounds like a perfect solution. And that can, in effect,
be relational.

Cheers, Rob.
Nov 21 '05 #2
Ok. XML it is.
Thanks Rob.

D.

"Rob Nicholson" <ro***********@nospam-unforgettable.com> wrote in message
news:uU**************@TK2MSFTNGP15.phx.gbl...
What are my options?


Thought about XML? Sounds like a perfect solution. And that can, in
effect, be relational.

Cheers, Rob.

Nov 21 '05 #3
Dennis,

You have almost no options when you say "more users have to use that", if
those all are allowed to do even one update. That would mean that you would
have to create a service to handle that file. Only a fool will do that when
he can use a free Access and free MSDE (when I only take the Microsoft
ones).

When it is only reading than your option is the XML dataset, which can gives
you the relations, however there is no need that you use that.

I hope this helps,

Cor
Nov 21 '05 #4
Hello Cor:
I was looking for something simple not unlike a comma delimited text file
that can be searched and edited, and XML will produce a simple solution.

Installing IIS and MSDE raises the level of security requirements, and I
didn't want to produce a distribution where the home user must set up a
server environment. The issue with Access for me is that most people don't
own it. I will look for the free Jet runtime distribution before proceeding
with the database coding. Thanks for reminding me.

Thanks Cor,
D.

"Cor Ligthert" <no************@planet.nl> wrote in message
news:eK**************@TK2MSFTNGP12.phx.gbl...
Dennis,

You have almost no options when you say "more users have to use that", if
those all are allowed to do even one update. That would mean that you
would have to create a service to handle that file. Only a fool will do
that when he can use a free Access and free MSDE (when I only take the
Microsoft ones).

When it is only reading than your option is the XML dataset, which can
gives you the relations, however there is no need that you use that.

I hope this helps,

Cor

Nov 21 '05 #5

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

Similar topics

7
by: mir nazim | last post by:
hi. i want to know if there is any flat-file relational database system available for python. i require it in a project. it should have following capabilities: 1. should be small and compact on...
13
by: raykyoto | last post by:
Hi all, I'm sure this is a popular question that comes up every few months here. Indeed, I've looked at some of the past postings, but I would like to ask things differently. Basically, I'm...
1
by: Tim Fierro | last post by:
Hello, I have had many years using flat file databases (File Express from way back) but am now at a company where a relational database is needed and would carry us into the future. Since I...
4
by: Ben | last post by:
So, at my place of employment, we use a national standard to transmit data between certain applications. This standard consists of a fixed width, flat file 4500-some-odd chars wide that contain...
14
by: vunet.us | last post by:
Hi, I would like to use flat file data storage instead of database. Since I am new to it, I am wondering: What text file extension is a safe one to store my data online and how cost- and...
9
by: FFMG | last post by:
In my site I have a config table, (MySQL), with about 30 entries; the data is loaded on every single page load. This is not the only call to the db, (we do a total of about 8 calls to the db). As...
9
by: =?Utf-8?B?TmF2YW5lZXRoLksuTg==?= | last post by:
Hello I am developing a system for user tracking. In this I am tracking all the visitors that came to my website. i developed this using a HTTPModule and storing the data in a SQL Server...
15
by: lxyone | last post by:
Using a flat file containing table names, fields, values whats the best way of creating html pages? I want control over the html pages ie 1. layout 2. what data to show 3. what controls to...
1
by: lxyone | last post by:
Using a flat file containing table names, fields, values whats the best way of creating forms / html pages? I want control over the html pages ie 1. layout 2. what data to show 3. what...
3
by: Flugeldorph | last post by:
I am new to Visual Basic, my preferred languages is C or C++. I am trying to load a local database with data that I am reading from a delimited flat file. I have created the database tables and...
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:
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.