5 ms·
All of my email is in Postgres. Ever heard of the IMAP server called Archiveopteryx? http://aox.org http://aox.org Arnt and Ahbijit know more about the email
by feld 13y ago
All of my email is in Postgres. Ever heard of the IMAP server called Archiveopteryx?
http://aox.org http://aox.org
Arnt and Ahbijit know more about the email RFCs than probably anyone else on the planet. Arnt has been involved in writing several RFCs himself. Aox is blazing fast and your mailboxes scale as large as you want. Millions of emails in a single mail folder is not a problem. It's also really nice that it handles deduplication of your mail at several levels.
- darklajid 13y agoThanks, I've never heard about that project, imap was cyrus, courier or dovecot for me (I run the latter). The dovecot developers claimed in various mailing list threads, that a SQL based backend would not make sense, not even performance wise. Interesting to see a different approach. What irks me is the FAQ entry claiming "If you have trouble with user authentication, edit the pg_hba.conf to allow trust or md5"... I - don't think that this is a good idea?
- feld 13y agoI've never had to do that before. That would require a very poorly configured Postgres server.
- Arnt 13y agoYes, it would require that. Such servers do exist, I'm sorry to say.
- Arnt 13y agoI wrote that sentence. Trust is not a good idea, in my opinion. But I know that some people disagree with me, and I have better things to do than discuss the issue with them. MD5 is fine, I think. If you allow randoms from the entire internet to connect, allowing MD5 won't hurt you much more. If you restrict connections to e.g. your own IP addresses using a packet filter or firewall, MD5 definitely will not hurt you.
- 616c 13y agoYeah, just want to say I heard about MailDB (I posted up another thread), but this sounds very interesting. I will definitely check it out.
- e12e 13y agoHow could I've missed this project? Looks like a nice alternative to http://www.dbmail.org/ http://www.dbmail.org/ .
- feld 13y agoYes, here is a technical comparison. http://archiveopteryx.org/faq/mailstore#dbmail http://archiveopteryx.org/faq/mailstore#dbmail
- gaadd33 13y agoJust curious, does anyone run Archiveopteryx in production at scale? Like at the scale that you start using Cyrus Murder with Cyrus IMAP?