Hi Sergio, How about this:
class item(db.Model): numVotes = db.IntegerProperty() url = db.LinkProperty() timestamp = db.DateTimeProperty(auto_now_add=True) You may need to shard the items if you expect more than 5 votes per item per second. On Feb 22, 8:59 pm, Sérgio Nunes <[email protected]> wrote: > Hi, > > I would like to have the community's advice about the best way to > implement a group + count feature. > Imagine a Digg-like application with a simple model to store user > votes (many details discarded for simplicity): > > class vote(db.Model): > url = db.LinkProperty() > timestamp = db.DateTimeProperty(auto_now_add=True) > > So, how would you compute a simple query like: ordered list of URLs > with most votes in the last hour. > As you might note, this is not a "global counter" since it depends on > a "filter". > > How should this be implemented? It the underlying model flawed? > Or is this simply a problem for which GAE is not the best option? > > Thanks in advance for your comments, > -- > Sérgio Nunes --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
