why an SQL Database?

[Derek Broughton]

Caleb Marcus wrote:

> On Sat, 2007-11-24 at 19:06 -0700, Scott (angrykeyboarder) wrote:
> 
>> is would work with IMAP?  I switched to IMAP from POP
>>  a year ago and I've learned that IMAP (while better for my needs) isn't
>> quite what I thought it was gonna be (it's slow and search is *beyond*
>> slow - compared to POP).
> 
> IMAP's advantage is also its greatest disadvantage... since all the mail
> resides on the server, searching through undownloaded headers takes a
> long time as the client has to download every message in order to search
> it. 

iirc (and it's a long time since I looked into this) that's not
hard-and-fast.  IMAP has the ability to do that searching on the server, so
using a dbmail backend with Postgre, full-text searching, and IMAP to
present the data to KMail or other MUA should be possible.  It _may_
require mods to the MUA to make it send the correct IMAP commands.
-- 
derek