From user-return-4421-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Wed Apr 15 01:52:47 2009 Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 48694 invoked from network); 15 Apr 2009 01:52:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 15 Apr 2009 01:52:47 -0000 Received: (qmail 68759 invoked by uid 500); 15 Apr 2009 01:52:46 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 68668 invoked by uid 500); 15 Apr 2009 01:52:46 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 68658 invoked by uid 99); 15 Apr 2009 01:52:45 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Apr 2009 01:52:45 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of zhengji.li@gmail.com designates 209.85.142.191 as permitted sender) Received: from [209.85.142.191] (HELO ti-out-0910.google.com) (209.85.142.191) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Apr 2009 01:52:39 +0000 Received: by ti-out-0910.google.com with SMTP id u3so268986tia.3 for ; Tue, 14 Apr 2009 18:52:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type :content-transfer-encoding; bh=Xz7h7skFfU0S3tHo+pmXiVV/LERi+XiGpnDMyTHnyro=; b=xZNMEf1RiO0SCU1sEx1ja74VDR59PM0xVvK9BXGoJeHSZxokRR415Aj7tIQq6TiDvS yGkchn7N22imJzXWcqyAc5dvtkOe+EkronHeojIscAguTumtKslKEPFkD5o6td0+zlcB nYnIalyX16A3D9f2oCRC37rKTebS1dCYTHN44= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=g7YnP4DVBQmljJhdKYNb6va9uSijg6R/3KBfKhM/Wm7M2GbvUH6UbRl7fZuPDkTC3G f2aHEj3QLzIzfN86TTOrZA070JXLUyfW/xJQWBQzflGFe51bMaYU3IzlX6Xy4boig1Dv CdWiEIz3Pax8jjuNEKLQXjooa4b9TMKSNZhqE= MIME-Version: 1.0 Received: by 10.110.33.15 with SMTP id g15mr706276tig.33.1239760337662; Tue, 14 Apr 2009 18:52:17 -0700 (PDT) In-Reply-To: <55047b710904130929g451af4abw62e6ccd7281fbd77@mail.gmail.com> References: <1A8CEBA7-32CF-4D47-BE52-6D31DB79B385@mac.com> <55047b710904130929g451af4abw62e6ccd7281fbd77@mail.gmail.com> Date: Wed, 15 Apr 2009 09:52:17 +0800 Message-ID: Subject: Re: using CouchDB for a finance manager? From: Li Zhengji To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Thanks for your information that makes me confident to use CouchDB for this task. Before getting start, I think to calculate the balance seems difficult, no matter it is schema-less or not. For example, if I delete a older transaction, then all balance in following transactions must be updated one after another. For CouchDB, maybe some views need to be rebuilt, too. It seems to be time consuming. (Suppose there is a balance field in each transation --- CouchDB doc.) Any idears for this? 2009/4/14 Nicholas Orr : > I've looked into doing my own accounting app as well. Sitting with an > accountant the main thing she had an issue with, in regard to all the > products currently available, is tracking what the amount is for on each > side of the transaction. > > Example, say I as an individual transfer $10K into a company I'm a director > of. On the individual side (withdraw) of the transaction info needs to be > recorded as one thing, then on the other side (deposit) different > information needs to be recorded. This whole transaction needs to exist in > both places so come tax time the account doing the work for tax can follow > everything simply. > > The concept of schema-less documents now starts to shine as ideal. I have a > few other projects on the go right now and will not be getting to this one > anytime soon. Interested in what you guys come up with :) > > Nick > > > -- Li Zhengji ------------------------------------------------------------- If all you have is a hammer, everything is a nail. -------------------------------------------------------------