[softwarelimits]

Would anybody please like to recommend a good sql schema (that makes sense) for storing emails (possibly downloaded with this fine piece of software). Also a hint about a maildir -> sql import tool would be interesting to see.

If you have already made your experiences with storing email in a sql database, it would be very appreciated if you would like to write about the pitfalls to avoid and the problems that occured.

Thank you very much for your attention!

[e12e]

I'd have a look at dbmail.org (an Imap server with a rdbms backend). If I've understood correctly, after some years they landed on a fairly straightforward schema with appropriate indexes.

There's also "Archiveopteryx": http://aox.org/

Another question is what do you want to do? I've not played that much with sql store for mail - but notmuch (and mailutils) make good use of Xapian for quick index/search of mail, if that is your end goal.