Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of tim@alwaysreformed.com
 designates 74.55.86.74 as permitted sender)
Message-ID: <51E5A8E5.1000508@alwaysreformed.com>
Date: Tue, 16 Jul 2013 15:11:17 -0500
From: Tim Black <tim@alwaysreformed.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:17.0) Gecko/20130623 Thunderbird/17.0.7
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: Trying to wrap my head around CouchDB
References: 
 <CAJ=2b077_DfJ67gQ38R88p0qXHjs4Rk0w7pWbspmc_OX1xQCzg@mail.gmail.com>
In-Reply-To: 
 <CAJ=2b077_DfJ67gQ38R88p0qXHjs4Rk0w7pWbspmc_OX1xQCzg@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------070304070107080808040100"

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

Yves,

These pages will help you with these questions:

http://guide.couchdb.org/editions/1/en/views.html
http://guide.couchdb.org/editions/1/en/lists.html
http://guide.couchdb.org/editions/1/en/cookbook.html

More specifically,

On 07/16/2013 02:51 PM, Yves S. Garret wrote:
> 1 - How is data represented in CouchDB as compared to MySQL?  
MySQL lets you define each table's schema in terms of what column names
and types are found in each table, and what indexes optimize searching
what columns in each table.
> How can I
> create (or visualize in
> my head) multiple tuples of the same type of data (as in a table that has
> columns of specific types
> and then each entry is a row)?  If I need to store multiple orders in a
> system (where the data looks
> roughly the same, how would that look?
In CouchDB, there is no schema, so you have more options for how to
structure your data, but a common way to mimic MySQL's tables in CouchDB
is as follows:

Each row of a MySQL table is one JSON document in CouchDB.  Each
document contains a "type" or "collection" (in backbone-couchdb, for
instance) attribute, so one example document could be {"type":"order",
"name":"Honda Accord", "amount":"10,000.00"}.  You could make other
documents which also contain the attribute "type":"order".  All these
"order" documents would be roughly equivalent to a table in MySQL named
"order".

To get all order documents in one request, write, then query, a view
which only emits documents if (doc.type == 'order').
> 2 - How is binary data handled inside of CouchDB?
As attachments to documents.
>   As in, how is data
> stored inside of CouchDB
> and then used (text and binary)?
Attachments can be directly accessed at a URL under the URL for the
document to which they are attached.

Tim


--------------070304070107080808040100--