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 sjtirtha@gmail.com designates
 74.125.78.25 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=dZrQUKiloUJBkiIu+um6zLBOz34IcYEyDrrWvGbrHGxOCnQYtZVXMtDWfclrQpRGMx
         /j4Ez42mHA0oA+7i+u8OEPNt0r3k9bjCvM7c/gd3WGCftJEBc1OipyfEfWwlz8W5JPx0
         tRLEZ4aqDcBC7K1fNjkWw6PtFPTXEXt+KrLy8=
MIME-Version: 1.0
Date: Thu, 20 Aug 2009 16:05:25 -0400
Message-ID: <b121f0f80908201305m7ea550f3we88c787151b461c2@mail.gmail.com>
Subject: CouchDB vs. SQL
From: sjtirtha <sjtirtha@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=00504502d422bed66604719845ed

--00504502d422bed66604719845ed
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi people,

I'm new in CouchDB. Before I looked into CouchDB, I was kind of
investigating what other no-SQL DB exists in the world.
There are MongoDB, Hadoop, Hypertable, Cassandra (correct me if I misspelled
any names).
And I found out the two big no-SQL DBs are Hadoop and CouchDB. Hadoop is
very interesting, but it is very big and complicated.
On the other hand, from some presentation I have the impression, Hadoop
should not use for a normal web application.
It is more for analytics data like Google and Yahoo do.

So I came to  CouchDB, which is also very interesting from the design and
implementing language(Erlang) point of view.
But somehow, it still does not 100% convince me to replace SQL with CouchDB.

One of the reason I like CouchDB very much is the  schemaless thing.

But I'm still not sure regarding following points:
1. performance. It is faster or same fast as SQL?
2. how can I reduce the data tranfer between my application and CouchDB,
when CouchDB always sends the whole document, although I only need a part of
it.
    This can be done very easy in SQL by selecting which columns should be
retreived from DB.
3. CouchDB support MVCC which is very good. But how is it, if I really want
to lock a document and other people should not be able to write.
4. Can I build a View based from other View?
5. Is there any Document Model Normalization as we all know in relational
DB? Because the Model Normalization from relational DB is a basic theory how
the relational model should look like. In CouchDB, it looks like that I can
do everything I want, but it may be a drawback for me in the future, if I'm
not design the document model very well.

CouchDB always put HTTP and Restfull as a very important things. But I don't
thing it is really complicated for SQL DB vendor to build a HTTP/RESTful
communication layer to their DB.

regards,
Steve

--00504502d422bed66604719845ed--