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

best format to store text

I am new to VB6 and need some advice...

I am developing software which aims to capture a text feed from a serial
port consisting of news stories in ASCII format and then save this text for
future editing. Each story is only a few paragraphs long - but each day the
news feed provides up to 100 stories. I had thought about saving each story
in an individual text file, or append each story into one large
random-access text file (eg one file per day), or lastly, I could use a
completely separate database.

The priorities are; allow multiple access to the same story over a network
for editing; carry out fast searches through large amounts of stored text;
use a reliable storage format which isn't prone to read/write errors or
corruption and; to use simple internal code and functions for accessing the
text. What do you reckon is the best format to store the text?

Regards
Tim
Jul 17 '05 #1
1 2837
If they are regula text files that don't go over 64Kb (roughly about 50
typewritten pages) in size (respectable for a mere story :-). You can save
it in a memo field in an Access database.

If they can get bigger than that, then singlefile approach would be better.
Remember that there's a file limit in the OS as in only so many file can be
created in a directory (folder). so at the worst I'd see about organizing
the stories in categories or something in that case.
--
Stéphane Richard
<ti*********@btopenworld.com> wrote in message
news:bo**********@sparta.btinternet.com...
I am new to VB6 and need some advice...

I am developing software which aims to capture a text feed from a serial
port consisting of news stories in ASCII format and then save this text for future editing. Each story is only a few paragraphs long - but each day the news feed provides up to 100 stories. I had thought about saving each story in an individual text file, or append each story into one large
random-access text file (eg one file per day), or lastly, I could use a
completely separate database.

The priorities are; allow multiple access to the same story over a network
for editing; carry out fast searches through large amounts of stored text;
use a reliable storage format which isn't prone to read/write errors or
corruption and; to use simple internal code and functions for accessing the text. What do you reckon is the best format to store the text?

Regards
Tim

Jul 17 '05 #2

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

Similar topics

7
by: | last post by:
In the beginning we had Ini files. Later we had registery files. Now have xml files and our read-only myapp.config file. My question now, is what is the best way to store and load user and...
5
by: Robert W. | last post by:
My app runs perfectly when run in Canada or the U.S. But others are experiencing problems. So I switched my computer to the UK culture and immediately saw a problem. This line was failing: ...
7
by: Richiep | last post by:
I am trying to get a UK format date of dd/mm/yyyy. Why does the following subroutine not return a valid date in a web form? The date returned is #12:00:00 AM# but the date I entered into the...
32
by: David Isaac | last post by:
I have no experience with database applications. This database will likely hold only a few hundred items, including both textfiles and binary files. I would like a pure Python solution to the...
4
by: jm.suresh | last post by:
Hi, Is there any standard text format for storing data of object oriented nature. The text file should be readable. That is, Is there any better way than having to write out a file like this...
29
by: gs | last post by:
let say I have to deal with various date format and I am give format string from one of the following dd/mm/yyyy mm/dd/yyyy dd/mmm/yyyy mmm/dd/yyyy dd/mm/yy mm/dd/yy dd/mmm/yy mmm/dd/yy
2
by: johnperl | last post by:
i am working on the script as below, i want an output according to the format. i am trying to put everything in one loop but cannot figure out the way to do so. could anyone please help me with this....
6
by: aagarwal8 | last post by:
Hi, I am trying to write the contents of a textbox to a file in binary format. My code looks like this... private void btnWriteToFile_Click(object sender, EventArgs e) { FileStream fs =...
21
by: Nick Craig-Wood | last post by:
Lance Gamet <lance@gamet.comwrote: I've found http://docs.python.org/lib/module-ConfigParser.html To be easy to use and built in. It makes human readable / editable ..ini - like files. ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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
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?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
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.