Application Data Storage Question

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Application Data Storage Question
Date: 2006-11-27 06:41:20
Message-ID: 131582.83237.qm@web33308.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-27 06:59:00 Re: Application Data Storage Question
Previous Message operationsengineer1 2006-11-27 03:47:21 Re: Which installer for Postgres on Windows?