Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Content-Transfer-Encoding: 7bit
Importance: normal
Priority: normal
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CA5741.2398AF34"
Subject: How Do You Model This?
Date: Tue, 27 Oct 2009 16:07:41 -0400
Message-ID: 
 <319C03F7A120754B9128CF308BF5E0370308FF05@nasa-dtw-ex004.nasa.cpwr.corp>
Thread-Topic: How Do You Model This?
Thread-Index: AcpXQSNRUyndWbygR2yb7ax3yPijZg==
From: "Welch, Matt" <Matt.Welch@compuware.com>
To: <user@couchdb.apache.org>

------_=_NextPart_001_01CA5741.2398AF34
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Ok, forgive my table structured background. I'm trying to see the light,
here, but I need help converting an SQL table based model into something
more CouchDB-ish. In an old-fashioned relational database it would look
similar to this: a users table and a permissions table.

Users:

Name	Group
-----------------
Alice	Developers
Bob	Developers
Carol	Developers
Eve	Managers
Frank	Managers

Permissions:

Group		Directory
---------------------
Developers	Source
Developers	Binary
Managers	Binary
Managers	Planning

Then I want to look up what directories Alice has permissions to, or
even make a master list of all the users and their permissions like:

Alice	Source
Alice	Binary
Bob	Source
Bob	Binary
...
Frank	Binary
Frank	Planning

I need to do the equivalent of adding and removing users, adding and
removing directories, and change group and permission assignments. None
of that can be static.=20

So how do I set up my data and views in CouchDB to do this kind of
thing? Or is this just not the sort of thing CouchDB will be good at
modeling?

Thanks in advance for your help.


The contents of this e-mail are intended for the named addressee only. =
It contains information that may be confidential. Unless you are the =
named addressee or an authorized designee, you may not copy or use it, =
or disclose it to anyone else. If you received it in error please notify =
us immediately and then destroy it.


------_=_NextPart_001_01CA5741.2398AF34--