Application Data Storage Question - Mailing list pgsql-novice

From
Subject Application Data Storage Question
Date
Msg-id 131582.83237.qm@web33308.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Application Data Storage Question  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: Application Data Storage Question  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
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.

tia...



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

pgsql-novice by date:

Previous
From: John Koller
Date:
Subject: Re: General Questions about PG
Next
From: Richard Broersma Jr
Date:
Subject: Re: Application Data Storage Question