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 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 >
