couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "paul jobs" <webjog...@gmail.com>
Subject Re: Couchdb views using time
Date Sat, 10 Jan 2009 07:41:16 GMT
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 <jchris@gmail.com> 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 <webjogger@gmail.com> 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 <webjogger@gmail.com> 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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message