Less Wrong is a community blog devoted to refining the art of human rationality. Please visit our About page for more information.

dfranke comments on Zero-based karma coming through - Less Wrong

6 Post author: Eliezer_Yudkowsky 08 April 2009 01:19AM

You are viewing a comment permalink. View the original post to see all comments and the full post content.

Comments (39)

You are viewing a single comment's thread. Show more comments above.

Comment author: dfranke 08 April 2009 09:51:18AM 0 points [-]

I just finished going through the source, and while it's still Postgres-based, the schema just uses five tables: type, rel_type, thing, data, rel. So yes, it's fundamentally just a key-value store. I bet I could still whip up some SQL that would do the trick, though it would be a good deal uglier than the above.

Comment author: wmoore 14 April 2009 01:29:21AM 0 points [-]

This is pretty much right, it uses a big key value store. The issue with karma is that the Account record maintains the karma value but the vote is stored as a separate relationship between the Account and the Link (article). Generally is is not safe to update the database directly as it is necessary to keep the separate memcache coherent. Thus any changes must be done via Python code. Whilst such a change is possible and relatively straightforward I'm not sure its worth it. From what I've seen there are no truly obnoxious users on less wrong that need to be dealt with by such a change.