Might I suggest you consider using dbmail as an IMAP server.
This indexing you speak of is exactly what it will do.
But the additional advantage with IMAP is that you can have multiple
clients attached to the same folders (especially useful if shared) or be
able to attach from multiple sources (notebooks, webpages, desktops) and
have all the same messages/folders each time.
On 1/29/2007, "Sim Zacks" <sim@compulab.co.il> wrote:
>DBMail is an interesting concept, but I think the real advantage would be if there were a client
>that could take advantage of the power of a database backend.
>
>For example, instead of saving a copy of an email in 1 folder, the same email could be indexed to
>multiple folders. Current email clients mimic file cabinets too much in that the system considers an
>email to be a physical entity that can only be stored in one place. Searching for emails can also be
>done much faster with a database then with a traditional mail client approach.
>
>However, to start out with, using dbmail imap with current email clients might be a great idea. Then
>the users will not even know that anything has changed, and I can basically build the client that I
>want directly into my ERP.
>
>Sim
>
>>
>> Well "client" would be the wrong approach imho, but there
>> is for example dbmail which can use postgres as storage
>> for mail and opens a lot of the usecases above. You would
>> continue to use your MUA for reading mail but some of the
>> mails could be handled by your application directly.
>>
>> Regards
>> Tino
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faq
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>QIDX:afa47a3e4ac627067728eb058e4b191f