On Fri, Jan 9, 2009 at 9:41 PM, paul jobs <[email protected]> wrote: > Thanks chris > Ok, but how to get the list of items that are in the last one hour, since > the list is about 3 million users
Paul, emit([doc.user, doc.sortable_timestamp], null) Paul > so extracting the 3 million using this view and then processing the results > in python doesnt seem feasible > thanks a lot > > On Fri, Jan 9, 2009 at 10:52 PM, Chris Anderson <[email protected]> wrote: > >> just have a map view that calls emit(doc.timestamp, null) as long as >> your timestamp format sorts correctly. >> >> On Fri, Jan 9, 2009 at 3:47 PM, paul jobs <[email protected]> wrote: >> > This is very useful for eg., to delete posts older than one day >> > get users who logged in the last 1 hour etc >> > >> > On Fri, Jan 9, 2009 at 3:47 PM, paul jobs <[email protected]> wrote: >> > >> >> select * from users where ((extract('epoch' from now()) - >> extract('epoch' >> >> from last_login)) < 3000000) order by last_login DESC >> >> >> >> is it possible to construct such views using couchdb permanent views? >> >> >> >> thanks >> >> >> > >> >> >> >> -- >> Chris Anderson >> http://jchris.mfdz.com >> >
