incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Newson <robert.new...@gmail.com>
Subject Re: Sorting view queries
Date Fri, 03 Jul 2009 11:59:34 GMT
wouldn't emitting the start timestamp as the key solve the problem?
(if you need both, have two views).

On Fri, Jul 3, 2009 at 12:44 PM, Nils Breunese<n.breunese@vpro.nl> wrote:
> Hello all,
>
> We set out to use CouchDB as a piece of software that can easily be used to
> create REST APIs. We publish documents to CouchDB, add some views and
> show/list functions, put Apache httpd+mod_rewrite in front for the pretty
> URLs and there is your super fast REST API!
>
> Well, that was the idea, but we ran into an issue. We have a view that
> returns events with start and end timestamps. It should be possible to ask
> the API for a list of current events and events that are upcoming. I thought
> I'd just emit the end timestamp as the key and query using
> startkey=currenttime. This returns the correct events, but the list is
> sorted by end timestamp.
>
> The API would make a lot more sense if it would return a list sorted by
> start timestamp, but I don't see a way to do this without adding some
> server-side logic to sort the results from the view query. This would mean
> adding another layer to the setup: more complexity and loss of performance
> probably. Is it really not possible to accomplish this with just CouchDB or
> do I miss some way of mapping and/or querying the data which does yield the
> desired result?
>
> Nils Breunese.
>

Mime
View raw message