On 04/23/2014 12:23 PM, Reindl Harald wrote: > > Am 23.04.2014 18:12, schrieb Jeffrey Starin: >> I have a general question about dbmail. >> >> Does dbmail store message parts separately into different fields in a record? > yes and no > > https://www.mail-archive.com/dbmail@dbmail.org/msg19777.html > >> For example, is the subject one field, message body another field, >> attachements yet another field? >> Or are all parts just stored as a blob in one field? > see above > >> using Mysql querries, can an administrator search, query and manipulate the >> records? > don't do that - the db-scheme may change and low-level tables > are no public interface, you can in theory but you have two > problems: > > * complexity / error-prone / safety (if you make mistakes you leak infos) > * not a stable interface > > in dbmail 2.x there was no de-duplication, all tools like my admin-backends > only working with the high-level tables are working unchanged, anything > touching message-bodies directly would needed to be rewritten > > > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail Ok thanks for the information. Perhaps dbmail is not what I need then.
I am looking for solutions for a project which needs to examine the content of subject and, based on content, kick of a seperate script. As well, attachments, which will always be an image file (.png, .jpg, etc.) need to be run against a script which extract embedded GPS latitude and longitude data. That data then needs to be re-associated with the email address (either re-integrated into the record for that sender as data into a separate field in a different table, or the same record for that sender). I was hoping dbmail could play a role in all of this as I had hoped it would segregate the message parts into distinct fields that could be used for analysis. Any gurus have some suggestions on whether dbmail would be a candidate for this or perhaps could suggest some other message store facility? Thanks!
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
