Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group