Proko2 is Good News Towards Kolab2

Jon Bendtsen jon at kollegiegaarden.dk
Thu Apr 8 16:49:20 CEST 2004


Den 8. apr 2004, kl. 16:09, skrev Bo Thorsen:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Thursday 08 April 2004 09:52, Ilja Booij wrote:
>> Hi,
>>
>> if you are considering using a database backend for all objects, you
>> might want to take a look at DBMail (http://www.dbmail.org), which is
>> an IMAP and POP3 server using a database (currently PostgreSQL and
>> MySQL are supported) as backend. The version that is currently in
>> development also supports IMAP ACLs. We also have somebody working on
>> Sieve scripting.
>
> Unless someone can actually describe advantages of storing the parts 
> in a
> database it's not going to happen. I'm sorry if this sounds harsh, but
> I've been hearing this suggestion for the last 18 months without a 
> single
> person being able to give a summary of the advantages over the current
> storing. And that would include a list of the disadvantages also - the
> biggest of these being a *huge* performance hit.
>
> I basically don't see a single good reason to store in a db, but 
> plenty to
> not do it.
>
> I dare you to prove me wrong :-)

Not that i like the database solution myself...
But would the database solution not make it easier to only store a 
message for many people
once, and even attachments once?  - storage is cheap

Searching through messages might be easier, if you could get an sql 
like interface?
doing advanced stuff like selecting all messages sent to one particular 
customer?

Sure it can be done using flat text files, but i do believe that there 
are some advantages into
having a database for easier manipulation of data, and perhaps 
statistics. My former employer
had a database with all emails sent to and from particular customers, 
so they could track that
information. It worked by duplicating the data into the database, but 
again - storage is cheap.



JonB




More information about the users mailing list