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

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

pgsql-novice by date

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

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