You have a big pile of posts and they have markers indicating where they go, what they
are, and their characteristics;
Well, Scoop uses mysql to store all the data, and all stories are in a huge table, named (appropriately enough) 'stories'. The primary key is the sid of the story. Comments, likewise, are in a big table named 'comments'. :)
One possible response to this would have been a comment from Rusty to the
effect of "build it and I'll put it in," in which case I might have just wandered over to SourceForge
to give the code a look-see.
I'm sure rusty wouldn't have a problem with using this on the site if it didn't cause huge performance penalties (and it shouldn't). Hell, the (x new comments) code causes more DB strain than this would. Sending a message to a user would be a single INSERT statement, and reading your messages wouldn't cause any more strain on the database than reading a diary entry (a single SELECT for the story, and a single SELECT for the comments, if that was how it was implemented). Keeping the "mail" private shouldn't cause _any_ database access; it would just be a comparison between your user ID (which Scoop already knows when it renders each page) and the user ID associated with the mail, which could be the section ID of your mail (like diaries use diary_1107 for the section of my diary, for example, mail could use mail_1107).
Wandering slightly off-topic, Scoop has some really STUPID things about it - the comment count for a story isn't stored in the database, it's calculated each time!! If rusty, hurstdog, or panner don't fix this soon, I will.
Starting cold it might take me a
few weeks. I can't imagine it taking much more than that unless Scoop's implementation is really
On the contrary, Scoop is some wonderfully readable code. It didn't take me more than 15 minutes to learn my way around and start changing and adding stuff.
So don't listen to Inoshiro when he speaks of these things which he does not understand. But he's forgiven; after all, he is Canadian.
Now, if you'll excuse me, my kitchen is starting to smell funny. Time to take the trash out.
GNU GPL: Free as in herpes.
[ Parent ]