Re: Using pgsql to archive e-mail - Mailing list pgsql-general

From KuroiNeko
Subject Re: Using pgsql to archive e-mail
Date
Msg-id 39F5FFAF.nail3RL11W913@ed.ed
Whole thread Raw
In response to Using pgsql to archive e-mail  (forhire@lewiscounty.com (Randall Smith))
List pgsql-general
> I am  looking for a way  that I can archieve  a lot e-mail messages  to a
> data
> base. I'm thinking of using pgsql.

 Been there, done that. Works OK  for me. Desreves a major rewrite, because
storing message  bodies as BLOBs  is useless  and dangerous. If  only there
were 25 hours in the day (sigh)
 So yes, it's  possible. And if you  know nothing about DBs and  SQL, get a
couple  of books  and start  there. There  are caveats  in a  general email
archive  application, so  you'll  be better  off  beginning with  something
simple.


--

 contaminated fish and microchips
  huge supertankers on Arabian trips
 oily propaganda from the leaders' lips
  all about the future
 there's people over here, people over there
  everybody's looking for a little more air
 crossing all the borders just to take their share
  planning for the future

 Rainbow, Difficult to Cure

pgsql-general by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: three things
Next
From: "Oelkers, Phil"
Date:
Subject: please get me off this list