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: domain of ido.ran@gmail.com designates
 209.85.213.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <E1A72B77-9E3A-40CE-9558-0860C746E54C@maf.org>
References: 
 <CAKvLi7Pj3dyqcf4n2FCjd=TtH91EM8d_H8xP=TeJSRPb7Ux13g@mail.gmail.com>
 <CACXzkS8nrXmMxAQeDWO=UkFhwUsenm4-6RSdNXp=nUxGMWExHg@mail.gmail.com>
 <71BB085F-7B41-4A79-8A65-FB94618DC622@gmail.com>
 <CA+u6u_Eyt9q1LvbScoTNr+dneNV4Y6aHgXzkOLaH-2bRmemYvA@mail.gmail.com>
 <0BDB9E38-5499-4151-AC6F-D1AD7965178F@gmail.com>
 <CAHZBNKatmtpK8OrBjoXD46ULP3A7DWCsyW04fPHvysYJz4t8Mg@mail.gmail.com>
 <CAKvLi7NB718XTFyJf6=OAOV7Y-tatLxTvTO+vgFqNQX9v+6+7A@mail.gmail.com>
 <E1A72B77-9E3A-40CE-9558-0860C746E54C@maf.org>
From: Ido Ran <ido.ran@gmail.com>
Date: Tue, 18 Oct 2011 12:05:05 +0200
Message-ID: 
 <CAKvLi7NaQjeJf8--J0qXAcaSEN3qXXLse117pGe45j+PRjWBeA@mail.gmail.com>
Subject: Re: Architecture Question
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=90e6ba6e836c63667b04af8fdd77

--90e6ba6e836c63667b04af8fdd77
Content-Type: text/plain; charset=UTF-8

Hello again,

I am developing a desktop application that run on Windows using WPF
interface. The application loading and saving data using RESTful web service
that is currently only a thin wrapper around relational database.

My design require the following things:

   1. Offline work - allow the users to work in offline mode when connection
   to the server is not working
   2. Sync between local and remote databases - Either online or manual sync
   between databases
   3. Conflict resolution - Both offline and sync may cause conflicts so I
   need a way to resolve them
   4. Security - I need to authenticate the user and authorize them
   according to security rules.

The first 3 requirements available in CouchDB out-of-the-box - the question
here is what data model to use in order to take advantage of those those
capabilities.
My model is close to the following (top to bottom):

   - ProcessGroup is a data entity with name and set of Processes
   - Process is a data entity with name and set of activities
   - Activity is a data entity with name and set of participants and set of
   properties

If I will create a document for ProcessGroup it will cause to much conflicts
even if two users change different activities. On the other hand if I model
each entity as it own document I can't be sure that when creating a Process
with 100 activities all of the activities will be added, for example a power
down in the middle of the process or CouchDB fail half way though the
addition. In other words there are no transaction out side a document.

Thank you all for the help,
Ido

On Mon, Oct 17, 2011 at 3:54 PM, Robert Wadholm <rwadholm@maf.org> wrote:

> If you are building a CouchApp, for simplicity, you can also maybe checkout
> Ryan Ramage's CouchApp Takeout:
> https://github.com/ryanramage/couchapp-takeout
> It will install CouchDB on Macs and PCs in the background (as well as your
> CouchApp) as long as the user has the latest Java. It'll install your
> CouchApp as a native looking app, and run it in the user's default browser.
> You can get CouchDB running on a user's machine in about 2-6 minutes
> (depending on download speed) without them having to know they have
> installed anything but your app. And CouchApp Takeout is extremely easy to
> set up (it's a CouchApp itself, so you just replicate it to your db, and
> make a few minor changes to JSON and two images).
>
> Bob
> rwadholm@maf.org<mailto:rwadholm@maf.org>
>
>
> On Oct 17, 2011, at 3:42 AM, Ido Ran wrote:
>
> Many thanks
>
> On Mon, Oct 17, 2011 at 10:36 AM, Dave Cottlehuber <dave@muse.net.nz
> <mailto:dave@muse.net.nz>> wrote:
>
> On 17 October 2011 07:16, Ido Ran <ido.ran@gmail.com<mailto:
> ido.ran@gmail.com>> wrote:
> Thank you all. I'm targeting Windows platform - so I'll be glad to hear
> how can I run the database there.
> It's not going to be in-process but I do need a seamless way to run it
> without the client install it manually.
>
> Thanks
>
> You can bundle couchdb inside another windows app without users
> needing to install it separately. Check
> http://wiki.apache.org/couchdb/Quirks_on_Windows "Integrating CouchDB
> into your Windows Applications", and make sure you include the
> appropriate VC runtimes either in your app or as a dependency.
>
> I've found that you can also remove the two erl.ini files completely
> and Erlang/CouchDB seems to run just fine without them. You'll still
> need to fiddle your local.ini files for the correct paths of course.
>
> A+
> Dave
>
>
>

--90e6ba6e836c63667b04af8fdd77--