On Wed, May 27, 2009 at 9:39 PM, Broken Maize <brokenmaize@yahoo.com> wrote:
>
>
> On Postfix setup thread.
> First of all, there is no such thing as storing mail in a database -mysql or

Actually there is. Lots of proprietary systems store mail in
databases. Even some open-source: look at
http://search.cpan.org/~rjbs/Email-Store-0.255/lib/Email/Store.pm.

> otherwise. The only stuff that would go into the database would be user
> credentials.

Agreed, IMHO only user credentials should go into the database, plus
other stuff like location of mailbox, status of account
(enabled/disabled/vacation etc), quota details..... which is why I
asked what's the reasoning behind wanting to store the actual messages
in a database.

> Secondly for performance use the "maildir" format, which supports indexing
> and hence scales well with speed of retrieving mail, indexing the mailboxes,
> etc.
> The alternative "mbox" format stores all mail in a single file, and this
> does not scale well. Enjoy!

Totally agreed. Maildir works great, mbox doesn't scale well and is
plagued with file locking issues.

Regards,
Steve

--
"A democracy is a sheep and two wolves deciding on what to have for
lunch. Freedom is a well armed sheep contesting the results of the
decision." - Stolen from someone else's sig.
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
Other services @ http://my.co.ke
Other lists
-------------
Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general