couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Davis <>
Subject Re: getting unique set of document id's
Date Sat, 04 Jul 2009 20:52:57 GMT
On Sat, Jul 4, 2009 at 2:48 PM, Ross Bates<> wrote:
> Hi All - finally got up an running with 0.9.0 and have been experimenting
> with the POST {"keys": ["key1", "key2", ...]} feature and have a question
> Take the typical example of a set of blog posts which can be tagged with
> 1...n tags. Pretend I want to find all posts tagged with both "foo" and
> "bar".
> A simple map would look something like this
> function(doc) {
>  for(i in doc.tags) {
>      emit(doc.tags[i], doc._id);
>    }
> }
> So now when I post {"keys": ["foo", "bar"]} to the view I get all the
> documents tagged "foo", "bar", and also duplicates for any document that is
> tagged with both.
> Is the best option to deduplicate the doc._id on the client and resubmit to
> all docs, or can this be handled in a reduce function?
> Thank you for any help!
> Ross
> -----
> @rossbates

Assuming the set of tags you want to query isn't known until query
time then you need to go with doing the client side intersection. A
method for making this process a bit faster is to create a view that
lists the tag count using a standard map/reduce of
doc.tags.forEach(function(tag) {emit(tag, 1);}); and a reduce of
"return sum(values)". Then query this view with the multi-key fetch to
get the list of docids for each tag, then query in order of ascending

Paul Davis

View raw message