Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of webjogger@gmail.com designates
 209.85.218.10 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=TZ43aWzdUiado4adLbVV6VTVbySbSc/kp0IWkEi1P/rtltXqdfUSyLfhN0SFKed+Rn
         Xla9RkJKxFNqzRgLxBOn5a94Gr9foiIMqiUZi/anzbvkGHaHhsz0LCo6TKRpRJa8/Zzf
         4GD60JJelKB9s6TMDyZp4oFs8fOA56nyskBCo=
Message-ID: <4c69d7170901100031s33f19cfv70e6fcc10d74b81b@mail.gmail.com>
Date: Sat, 10 Jan 2009 00:31:45 -0800
From: "paul jobs" <webjogger@gmail.com>
To: user@couchdb.apache.org
Subject: Re: Couchdb views using time
In-Reply-To: <e2111bbb0901092351w53d18862gbcbc9b747825eec9@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_217590_23963298.1231576305219"
References: <4c69d7170901091547w6f43b7c1wf9612ff459ba8c7a@mail.gmail.com>
	 <4c69d7170901091547g2a42a2ccnccfdc38482b4e5c4@mail.gmail.com>
	 <e282921e0901092252u3dd95ee2xdec757512b7a5446@mail.gmail.com>
	 <4c69d7170901092341j512473e3wc6f31c7bcf78619d@mail.gmail.com>
	 <e2111bbb0901092351w53d18862gbcbc9b747825eec9@mail.gmail.com>

------=_Part_217590_23963298.1231576305219
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

so paul what you are saying is this
so if we use sortable_timestamp or created/date/time in my case
the rows are automatically sorted in descending order and use the 1st 100 u
get and process them in python

is it possible to construct this in the view itself and get like the 340
items that are created in the last one hour without resorting to python
Sorry if i am asking something basic
Thanks
On Fri, Jan 9, 2009 at 11:51 PM, Paul Davis <paul.joseph.davis@gmail.com>wrote:

> On Fri, Jan 9, 2009 at 9:41 PM, paul jobs <webjogger@gmail.com> 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 <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
> >>
> >
>

------=_Part_217590_23963298.1231576305219--