IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New What exactly happens each week?
Do you pick a date for all users and anything before that which hasn't been explicitly saved rolls off? Or each week you find the oldest unread item for each user and set that as the "mark read" date for the category? I like the second, but I think you're talking about the first. The thing I don't like about that is that I could be away for a while, and when I come back I'd want to see the same state as when I left. (Plus new items of course.)

I'm not sure how my preference would affect the queries you're doing.


As to "formalizing" the articles, I'm thinking the same thing. But for it to be meaningful, I think you'd have to have some sort of restriction on who can post an article. Whether it's a user-filtered queue ala K5, editorial selection ala /., or list of approved editors ala IWE or other trade pubs. In one sense it's just another launch point, but there has to be some exclusivity to it or it's useless.

That's why I suggested three different types of main page. Right now we're a free-form site. Someone using this software for a site like The Register or LinuxToday would want something that sees the article as the main thing, but with richer discussion than they have now, and a place to put open content.
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
New Re: What exactly happens each week?
The idea is that posts older than say 6 months would be archived.

Mark read tuples are the user ID, the begin post ID of the tuple, and the end post ID of the tuple. If a post's ID is within a tuple's range and not in a save list for the user, it's considered 'read'.

So each week:
  1. Figure out the highest post ID older than 6 months.
  2. That becomes the new limiter ID.
  3. For each user, delete all read tuples where end_post_id <= limiter.
  4. If a tuple remains that has begin_post_id < limiter, set begin_post_id = limiter.

Now all queries looking for unread posts do two things:
  1. add a where clause: id > limiter
  2. look in the read tuples for that user to make sure it isn't marked read
  3. look in the saved list to see if it's saved anyways.

For the alternative, each category and article gets a mark read date per user. Then the articles go through the same aging process (but probably something more like the last 50 articles, or whatever) and the mark read stamps get pruned accordingly.

And actually what I'm talking about with respect to articles is original content (like one of Andrew's amazing culinary discussions) with trusted users and possibly submission queues. Links to outside articles would have a submission queue as well, with a link and a fair-use quote.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
New Guess I was being pessimistic
Not having done the math, I didn't think it would be practical to actually keep the tuples you describe for all users for any useful length of time. Now if I'm reading you right, 6 months becomes a hard limit, and if you're away longer than that you lose your history? Seems like plenty long enough to me. I'm just surprised that you can keep tuples that long for the number of users and posts you cite without killing performance.
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
New Tuple space depends on holes.
If people don't reliably mark everything read, then the tuple-space will grow very large. However, I think most people keep up-to-date on that sort of thing, but yes, this sort of system can develop some pathological behavior.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
     This is a bit more involved than I thought. - (admin) - (35)
         Perhaps turn the problem around... - (ChrisR) - (23)
             Re: Perhaps turn the problem around... - (admin) - (22)
                 Just thinking of the way I'd use it.... - (ChrisR) - (21)
                     Seconded - (drewk) - (20)
                         OK, I'll buy that, but... - (admin) - (19)
                             Just hypothetically, right? ;-) - (drewk) - (16)
                                 Of course not. - (admin) - (15)
                                     I would mark Articles and Threads separately. - (Another Scott) - (10)
                                         I see your point about linking discussion to articles ala /. - (drewk) - (5)
                                             Why not both? - (admin) - (4)
                                                 What exactly happens each week? - (drewk) - (3)
                                                     Re: What exactly happens each week? - (admin) - (2)
                                                         Guess I was being pessimistic - (drewk) - (1)
                                                             Tuple space depends on holes. - (admin)
                                         On making things general: - (admin) - (3)
                                             I hope I haven't seen the GUI already. - (Another Scott) - (2)
                                                 My God, it's full of... - (admin) - (1)
                                                     :-> -NT - (Another Scott)
                                     I *told* you I didn't think before typing, didn't I? - (drewk) - (3)
                                         The trick is size and performance... - (admin) - (2)
                                             You mis-spelled "laddies" -NT - (drewk)
                                             ICLRPD (new thread) - (ben_tilly)
                             Thoughts about articles... - (static) - (1)
                                 That's how I've been thinking about them. - (admin)
         Save database space and do it client-side - (pwhysall) - (3)
             I could be wrong... - (ChrisR) - (2)
                 Re: I could be wrong... - (admin)
                 You could use lots of them - (pwhysall)
         hmm, a non programmers answer - (boxley) - (2)
             And if there are 250K users...? -NT - (admin) - (1)
                 bigassed hashed key :-) -NT - (boxley)
         Try a variation of the Usenet approach? - (Another Scott) - (1)
             That was my idea as well - (tuberculosis)
         Alternatively... - (pwhysall) - (1)
             Size. - (admin)

Too hard to follow.
60 ms