Re: Application Data Storage Question - Mailing list pgsql-novice

From
Subject Re: Application Data Storage Question
Date
Msg-id 738212.39107.qm@web33305.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Application Data Storage Question  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
> On Monday 27 November 2006 01:41,
> operationsengineer1@yahoo.com wrote:
> > I'm working on an application that will need to
> store
> > all sent and received emails in logical groupings
> - in
> > my case, each transaction will have an email
> history
> > associated with it.
> >
> > i can conceive of two ways to store the email
> data.
> >
> > 1. stick all pertinent email info in a db linked
> to
> > the transaction id.
> > 2. create a transaction id directory in the file
> > system and store a file for each email
> sent/received
> > with all the pertinent info within that file.
> >
> > the user needs this functionality to provide an
> > archive of the transaction.
> >
> > i'm not experienced enough to know the pros and
> cons
> > of either process, or if there is a better process
> i
> > haven't thought of.
>
> It sounds like you have storage and retrieval needs
> based on an index.  Why
> not use the database?
>
> Sean
>

Sean, thanks.  now that i think about it, it would be
nice to print out all the emails on one sheet instead
of look through a number of files.

i think i'll go that direction.



____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Application Data Storage Question
Next
From: brian stapel
Date:
Subject: FW: Dropped Functions Still Appearing