Arc Forumnew | comments | leaders | submitlogin
3 points by krapp 79 days ago | link | parent

Tags imply a many-to-many relationship, don't they? How difficult would that be to do efficiently in News, without a proper relational database?

2 points by i4cu 78 days ago | link

> Tags imply a many-to-many relationship.

I don't believe so, but it depends on what relationships and queries you have in mind.

I think you just need to maintain an index of story ids for each tag then alter the page list code to check each story against chosen tag indexes in order to apply custom filters. And you will also need to bypass the page caching operations for these filtered pages (just given the number of combinations that are possible).

Obviously db capabilities would make it (and everything else) much better, but it's not a showstopper.


4 points by i4cu 78 days ago | link

> I don't believe so.

I shouldn't post in the middle of the night... of course it's many-to-many... I was attempting to say I don't believe it will be a problem.

The rest of my comment should hold true.