Re: Application Data Storage Question

From: <operationsengineer1(at)yahoo(dot)com>
To: sdavis2(at)mail(dot)nih(dot)gov, pgsql-novice(at)postgresql(dot)org
Cc: operationsengineer1(at)yahoo(dot)com
Subject: Re: Application Data Storage Question
Date: 2006-11-27 15:55:05
Message-ID: 738212.39107.qm@web33305.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> On Monday 27 November 2006 01:41,
> operationsengineer1(at)yahoo(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message brian stapel 2006-11-27 16:07:41 FW: Dropped Functions Still Appearing
Previous Message Sean Davis 2006-11-27 11:45:21 Re: Application Data Storage Question