I'm using the GNU NNTP API to connect to a NNTP server, leafnode, running on localhost. This API uses javax.mail.Message and there's no convenient way to lookup a specific Message without opening a Folder and searching through the messages, which is fine for a small number of articles, but not for a large number of articles.
Which leads me to the bad idea of persisting javax.mail.Message objects to database. A typical header looks like so:
The last header, Xref, has the article number. (Unfortunately, this API provides no mechanism for looking up articles by their number.)
Obviously, I don't need all of those headers. However, for design should that be a many-to-many between the articles table and the headers table? Or, should I just have a table with some of those headers for columns?
The content is generally plaintext, but could have html or jpeg's. I'm not dealing with large attachments, at worst an image or two. Mostly text. Should the content be in its own table?
thanks,
Thufir
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!