In CouchDB, how to get documents limited on value in related document? In terms of SQL, how to make WHERE on JOINed table

Posted by amorfis on Stack Overflow See other posts from Stack Overflow or by amorfis
Published on 2009-12-12T17:41:37Z Indexed on 2011/03/10 16:10 UTC
Read the original article Hit count: 249

Filed under:

couchdb

Crossposting from [email protected]

Assume we have two kind of documents in CouchDB. Person and Car:

Person:

_id
firstname
surname
position
salary

Car:

_id
person_id
reg_number
brand

So there is one to many relationship. One person can have many cars.

I can construct map function to get every person and his/her car next to each other. In such case key is array [person.id, 0] and [car.person_id, 1].

What I can't do, is limiting this view to owners of specific brand only, e.g. if I need salaries of owners of Ferrari.

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

In CouchDB, how to get documents limited on value in related document? In terms of SQL, how to make WHERE on JOINed table - Developer IT

In CouchDB, how to get documents limited on value in related document? In terms of SQL, how to make WHERE on JOINed table

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