On Postfix setup thread. First of all, there is no such thing as storing mail in a database -mysql or otherwise. The only stuff that would go into the database would be user credentials. 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! --- On Wed, 5/27/09, Steve Muchai <smuchai@gmail.com> wrote: From: Steve Muchai <smuchai@gmail.com> Subject: Re: [Skunkworks] Postfix maildir. To: "Skunkworks forum" <skunkworks@lists.my.co.ke> Date: Wednesday, May 27, 2009, 5:41 AM On Wed, May 27, 2009 at 3:04 PM, David Ndambuki <damundx@gmail.com> wrote: [.......]
And yes, I would like to store the e-mails in a mysql database instead of a home directory (maildir format).
What's the motivation behind this? I remember seeing some posts on exim-users or similar list some time back, arguing the merits and demerits of storing the actual email content in a database. I can't remember any of the arguments for/against this, however. IMHO, storing user info in a database is as far as I'd go (actually, have done) and leave the mail on the good old filesystem, but it would be great to know of any compelling reasons to go the whole 9 yards. I'm not saying you're doing the wrong or right thing, I'd just like to learn from your point of view.
I've already started on it, will get back to you soon.
Watching this thread...please keep us posted. Including any gotchas.... 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