Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
From: Andreas Owen <aowen@swissonline.ch>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Subject: proper nosql modelling
Message-Id: <B63DCC99-5BE4-4256-81D1-033DAC3C8901@swissonline.ch>
Date: Sat, 10 Dec 2016 11:15:39 +0100
To: user@couchdb.apache.org
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
archived-at: Sat, 10 Dec 2016 10:15:58 -0000

=08I have read a couple of articles about couchdb and nosql modelling =
because I=E2=80=99m finally changing from mysql. Unfortunately I still =
haven=E2=80=99t been able to answer a couple of questions, maybe someone =
can enlighten me.

i have a design document with views,lists,templates that make up an app =
and i=E2=80=99m using the builtin web-server. My app works with =
appointments in calendars where i have to check overlapping and minimum =
separation time on so on. that means i=E2=80=99m working a lot with date =
ranges, durations and weekNumbers. Appointments can also have =
linked/nested documents so sometimes i have to fetch other docTypes with =
a doc.

questions:
- should view only contain _ids or also all the data you want to fetch?

- what do you do about nested Documents, get them in the view or fetch =
the while rendering using lists / shows / templates (design doc)? For =
example calling db.openDoc() in list to get data of doc or nested doc.

- when i check for overlapping should i use views and then write a =
js-function to step through all results and check stuff or is it better =
to use nQ1-queries (pseudo-sql)? For example:
	appointment2.start >=3D appointment1.end + minSeperationTime && =
appointment2.end <=3D appointment3.start + minSeperationTime