473,394 Members | 1,140 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.

Beginner design question

Hi,

I'm curious how others would deal with something I'm building.
The app itself is a form of diary; it allows the organisation of diary
entries and a number of other data types.
Each diary entry is listed under its title, and double clicking brings
up the full entry and options for editing.
Each entry and associated option is stored in a diary object instance.
I'm wondering how best to store the persistent data. One option is
to a file on the users HDD. Each time the app is opened the file is
read and all diary instances are recreated. But I'm worried that
storing every diary instance in memory will create an ever increasing
memory footprint.
The other option I've thought of is creating a db file on the users
HDD, and only reading what information is needed. For example, when a
list of diary entries is shown, just the title fields are read into
memory. On double clicking a title, the entire record is fetched and an
instance of diary object created.

Which one of these would be the best solution? Or is there something
else more suited?

Another quick question: Are there any pre-made controls for the
richtextbox control? E.g. bold, italic, font type, colour buttons etc?
Or do all have to be created?

Any help would be appreciated!

Paul

Dec 19 '05 #1
2 1146
Is this for personal / local use, or intended for a wider audience?

If this is for personal use, or use amongst friends, keep in mind that
most computers these days have enormous amounts of memory. It would
take one heck of a prodigious and dedicated writer to fill up 512 Mb,
IMHO.

That said, if this is intended as a commercial product then you have to
be pickier about resource usage.

In the former case, the quick-n-dirty solution is to simply place the
entries in an XML file. When you start the app, read the XML into
memory, add an edit entries, then write it out again when your app
exits (or do intermediate saves to guard against data loss on crashes).

However, if this is to be a "real" application, you really do need to
use a database. MS just came out with SQL Server Express, which I
believe is a freely-distributable mini version of SQL Server for the
desktop. This would be ideal. You could also use an Access database,
but personally I think that Access isn't long for this world, so I
wouldn't recommend that.

A database would certainly make for a longer-lived, better-functioning
application. The XML solution is just a quicky.

If you really wanted to be clever, you could design yourself a data
layer interface something like this:

public interface IDiaryDataLayer
{
DiaryEntrySummaryCollection GetSummaries();

DiaryEntry GetEntryDetails(DiaryEntrySummary entry);

void InsertEntry(DiartyEntry entry);

void UpdateEntry(DiaryEntry entry);
}

....and any other methods or properties you'll need from your data
layer. Then you could write the XML data layer:

public class DiaryXmlStorage : IDiaryDataLayer
....

in order to test your application, then, later, you could work on the
database layer:

public class DiaryDataBaseStorage : IDiaryDataLayer

and just plug it in in place of the XML data layer. In fact, you could
write any class you wanted and so long as it implemented
IDiaryDataLayer, your diary application could use it to store and
retrieve diary entries.

Dec 19 '05 #2

"Bruce Wood" <br*******@canada.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
desktop. This would be ideal. You could also use an Access database,
but personally I think that Access isn't long for this world, so I
wouldn't recommend that.


Note that MsAccess is also a stripped SQL Server internally.
But it requires a Office license and so I agree. SQL Express 2005 is a great
chioce.

- Michael S
Dec 20 '05 #3

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

Similar topics

44
by: lester | last post by:
a pre-beginner's question: what is the pros and cons of .net, compared to ++ I am wondering what can I get if I continue to learn C# after I have learned C --> C++ --> C# ?? I think there...
14
by: z_learning_tester | last post by:
But I can't seem to find the answer. The question is how do you reverse the words in a string? Or how do you reverse the numbers listed in a string? The example is usually something like: Turn...
17
by: C_beginner | last post by:
Am I did the following program corectly according to the question? Question: /* 1:You have just been employed by MacroMuscle, Inc. (Software for Hard Bodies). The company is entering the...
4
by: --- | last post by:
I'm writing up a sample program to teach someone the basics of database application design. I'm using the 2.0 framework and Microsofts default "pubs" database. What I'd like to do is create a...
3
by: anke | last post by:
hi all, i am fairly new to css. i know the very basics, can work with scripts and adapt them. i learned webdesign in the late 90ies and have troubles forget about my beloved tables ;-) anyway,...
4
by: Johs | last post by:
I am looking for a good C++ book for beginners. I have some experience with C and a lot of experience with Java. I am currently reading Bjarne Stroustrups C++ Programming Language but it starts off...
5
by: macca | last post by:
Hi, I'm looking for a good book on PHP design patterns for a OOP beginner - Reccommendations please? Thanks Paul
6
by: Solo.Wolve | last post by:
I've just finished the K&R c, And begin to study c++ myself,so can anyone give me some advice?such as some books to read,and something to notice? Thank you very much.
4
by: subramanian100in | last post by:
In the book, C++ Coding Standards book by Hereb Sutter and Andrei Alexandrescu, in Item 40 on pages 86-87 viz, "Avoid providing implicit conversions", the authors have advised the use of named...
2
by: nicholas08 | last post by:
I am new to programming and trying to work on a simple console app. I am making a simple Library Management system where the user/admin can manage members and item. Attaching the menu so it's clear...
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...
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
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...

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.