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

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to