News for hackers. Stuff that matters.
Re:Steve Huffman on Lessons Learned at Reddit by akkartik on Saturday May 08, 2010 @05:11PM (#1330934)
The approach he recommends - no scheme, extreme denormalization, lots of redundancy - is a strong case for nosql.
Re:Steve Huffman on Lessons Learned at Reddit by alexro on Saturday May 08, 2010 @08:47PM (#1331266)
Reddit in fact now runs on Cassandra - the top nosql solution for a social website
Re:Steve Huffman on Lessons Learned at Reddit by metachris on Sunday May 09, 2010 @06:21AM (#1331809)
That's interesting. The guys at reddit previously compared various database systems including Amazon's SimpleDB, and found that PostgreSQL was the fastest (see 'Scaling your Python application on EC2' from PyCon 2010: http://pycon.blip.tv/file/3257303/ )

Appearently Reddit switched over to Cassandra in March 2010 (http://blog.reddit.com/2010/03/she-who-entangles-men.html)

Re:Steve Huffman on Lessons Learned at Reddit by jbellis on Sunday May 09, 2010 @06:55PM (#1332997)
To clarify, Reddit replaced memcachedb w/ cassandra entirely, but a lot of the site is still on postgresql. My understanding is they plan to move more to Cassnadra gradually.
Re:Steve Huffman on Lessons Learned at Reddit by bh23ha on Saturday May 08, 2010 @08:07PM (#1331209)
Shouldn't lots of redundancy be a fundamental part of which ever db you are using.

As to extreme do-normalization, colour me sceptical, why not parallelise and throw more hardware at the problem?

Re:Steve Huffman on Lessons Learned at Reddit by dalore on Sunday May 09, 2010 @07:21AM (#1331845)
Because it's more cost effective to de-normalize then to parallelise in this instance.
Re:Steve Huffman on Lessons Learned at Reddit by jbellis on Sunday May 09, 2010 @06:56PM (#1332998)
Turns out it's difficult to parallelize without also denormalizing...
Re:Steve Huffman on Lessons Learned at Reddit by akkartik on Saturday May 08, 2010 @11:04PM (#1331444)
*schema