How do I do the SQL equivalent of "DISTINCT" in CouchDB?

Posted by Blaine LaFreniere on Stack Overflow See other posts from Stack Overflow or by Blaine LaFreniere
Published on 2010-03-28T20:14:42Z Indexed on 2010/03/28 20:33 UTC
Read the original article Hit count: 326

Filed under:

couchdb

I have a bunch of MP3 metadata in couchDB. I want to return every album that is in the MP3 metadata, but no duplicates.

A typical document looks like this:

{
   "_id": "005e16a055ba78589695c583fbcdf7e26064df98",
   "_rev": "2-87aa12c52ee0a406084b09eca6116804",
   "name": "Fifty-Fifty Clown",
   "number": 15,
   "artist": "Cocteau Twins",
   "bitrate": 320,
   "album": "Stars and Topsoil: A Collection (1982-1990)",
   "path": "Cocteau Twins/Stars and Topsoil: A Collection (1982-1990)/15 - Fifty-Fifty Clown.mp3",
   "year": 0,
   "genre": "Shoegaze"
}

Related posts about couchdb

How-to index arrays (tags) in CouchDB using couchdb-lucene

as seen on Stack Overflow - Search for 'Stack Overflow'
The setup: I have a project that is using CouchDB. The documents will have a field called "tags". This "tags" field is an array of strings (e.g., "tags":["tag1","tag2","etc"]). I am using couchdb-lucene as my search provider. The question: What function can be used to get couchdb-lucene to index… >>> More
CouchDB crashes at startup when path to config file has space(s)

as seen on Server Fault - Search for 'Server Fault'
I'm hoping to run CouchDB as a per-user Launch Agent on OS X. I'm using the coucdbx-core folder from the CouchDB Server.app as the base of my CouchDB deployment. I'd like each user to have their own couch instance (on a different port), necessitating separate config files for each instance. The logical… >>> More
How to remove all Couchdb versions in Ubuntu 10.04 (server)? ( after multiple installs )

as seen on Server Fault - Search for 'Server Fault'
Hi all, I have done multiple installs of CouchDB using sudo aptitude install couchdb sudo ap-get install couchdb and more recently based on the instructions found at L http://wiki.apache.org/couchdb/Installing_on_Ubuntu May I know how do I uninstall or remove all the above installations? Best… >>> More
How can I proxy couchDB as a sub-diectory with lighttpd?

as seen on Server Fault - Search for 'Server Fault'
I have a sub-directory on my web server (lighttpd) that I want to point at a CouchDB instance running on the same machine. I tried using mod_proxy but it sends along the whole request, like a proxy should, I know! So: // What happens: Lighttpd: http://localhost/couchdb/some_request | V CouchDB:… >>> More
Map/Reduce on an array of hashes in CouchDB

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, I am looking for a map/reduce function to calculate the status in a Design Document. Below you can see an example document from my current database. { "_id": "0238f1414f2f95a47266ca43709a6591", "_rev": "22-24a741981b4de71f33cc70c7e5744442", "status": "retrieved image urls"… >>> More

Developer IT

How do I do the SQL equivalent of "DISTINCT" in CouchDB? - Developer IT

How do I do the SQL equivalent of "DISTINCT" in CouchDB?

couchdb

Related posts about couchdb

How-to index arrays (tags) in CouchDB using couchdb-lucene

CouchDB crashes at startup when path to config file has space(s)

How to remove all Couchdb versions in Ubuntu 10.04 (server)? ( after multiple installs )

How can I proxy couchDB as a sub-diectory with lighttpd?

Map/Reduce on an array of hashes in CouchDB

Categories cloud