[development] One-to-one tables considered harmful
merlin at logrus.com
Tue Jun 5 16:53:17 UTC 2007
Mark Fredrickson wrote:
> Flame war aside, I think there are some good points in this thread.
> Perhaps someone can clarify two points:
> 1. Is it kosher to add columns to other modules' tables? E.g. Is it ok
> for comment to add it's statistics to the node table. Similarly, I
> could imagine the stats module would want to add summary information,
> and perhaps other modules as well.
At one point we had a 'field' op to nodeapi that let modules add fields to the
node table. I would like to see this restored. Then we could justify never ever
having a 1::1 relationship table for 'node'. This was taken out when the
node_revisions table was added.
Which leads me to another question: Should the 'current' node_revision be
reflected in the node table, to eliminate that join if we need to sort/query on
something in that table?
More information about the development