Chris J. Davis wrote: > Is there some reason why we shouldn't be keeping this info in the > postinfo table?
Yes. You can't query on it there. You can fetch posts by postinfo, but if you stack authors on a post, the only practical way to store more than one additional author is with an array, and arrays stored in postinfo are serialized. Querying on serialized arrays is inefficient. Querying on authors would be used particularly by a recent case patched in Trac (too lazy to look up right now) that adds author archive output rewrite rules. Searching for contributing authors in addition to primary authors (different tables, one data field serialized) would be a nightmare when using postinfo to store this data. It would be better to have a dedicated table for the data, relating posts to authors, and provide an additional field that grants special qualities to an author. This would be used for official bylines; the "major author". If the intent is to only output contributors in addition to the post and its main author, then postinfo would be fine. But if equal weight is ever to be assigned to to users as authors of a post for the purposes of retrieving posts, then postinfo is insufficient. This message doesn't represent a positive or negative comment about actually implementing this feature. Owen --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/habari-dev -~----------~----~----~----~------~----~------~--~---
