Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a email inbox that will soon hit 4 million messages, I have an app that runs different policies over the inbox to associate emails with each other much like the conversation plugin for Thunderbird. It is now becoming impossible to do so and I have been thinking about moving the emails to a DB as they come in and process them there and then, the processor needs to access the body and header. What database engine is best for this task mysql,postgre,etc?

share|improve this question

migrated from stackoverflow.com Oct 28 '11 at 15:00

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 2 down vote accepted

You could try DBMail as local IMAP storage, and either use any of various IMAP syncing solutions or regular SMTP forwarding to get the mail in there.

share|improve this answer
    
I dont know much about DBMail my self, but it seems like to use this I have to replace everything on the server by DBMail and let it handle everything from user authentication to mail storage, although DBMail seems attractive, I was more looking for a mirror rather than replacement, is thatpossible? –  Max Oct 28 '11 at 16:10
    
Hence the suggestion to use IMAP synching. –  Peter Eisentraut Oct 28 '11 at 16:11
    
I have no idea what :" IMAP syncing solutions" Are :( –  Max Oct 28 '11 at 16:12
    
freesoftware.zona-m.net/… seems like dbmail is not an option for what I need –  Max Nov 1 '11 at 10:10

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.