Re: Design question, article with logs of comments and ratings

2011-03-02 Thread Simon Metson
Also the "Joins Redux" on http://blog.couchone.com/post/446015664/whats-new-in-apache-couchdb-0-11-part-two-views is handy, probably does what you want for comments... Sent with Sparrow On Saturday, 26 February 2011 at 04:32, Aravinda VK wrote: This might help. > http://www.cmlenz.net/archives/

Re: Design question, article with logs of comments and ratings

2011-02-25 Thread Aravinda VK
This might help. http://www.cmlenz.net/archives/2007/10/couchdb-joins On Sat, Feb 26, 2011 at 7:46 AM, He Shiming wrote: > On Fri, Feb 25, 2011 at 9:25 PM, Simon Metson > wrote: > > And query it for a specific article with > > > > > http://localhost:5984/voting/_design/vote/_view/vote?group=tru

Re: Design question, article with logs of comments and ratings

2011-02-25 Thread He Shiming
On Fri, Feb 25, 2011 at 9:25 PM, Simon Metson wrote: > And query it for a specific article with > > http://localhost:5984/voting/_design/vote/_view/vote?group=true&key=%22foo%22 > > Mike Miller did a nice summary of how you could do time binned data for your > historical info (using the timestamp

Re: Design question, article with logs of comments and ratings

2011-02-25 Thread Simon Metson
Hi, Let's say you have a +1 or -1 vote for a given document. You could record this with a document like: { "article" : "article-id", "vote": 1, "timestamp": now() } or { "article" : "article-id", "vote": -1, "timestamp": now() } (where now() is some function you run cl

Design question, article with logs of comments and ratings

2011-02-24 Thread He Shiming
Hi, I've got a design question. The scenario is: the database stores a series of articles, and each article can be commented and rated. For articles, naturally I'll have {"_id": "article-id", "type": "article" ...} . And each article is a single document in the database. I'm not sure what form s