Mailing-List: contact commits-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@couchdb.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
From: Apache Wiki <wikidiffs@apache.org>
To: Apache Wiki <wikidiffs@apache.org>
Date: Fri, 25 Feb 2011 17:23:25 -0000
Message-ID: <20110225172325.16174.61320@eosnew.apache.org>
Subject: 
 =?utf-8?q?=5BCouchdb_Wiki=5D_Update_of_=22DumpOracleDbToCouchDbPython=22_?=
 =?utf-8?q?by_DougShawhan?=

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Couchdb Wiki" for c=
hange notification.

The "DumpOracleDbToCouchDbPython" page has been changed by DougShawhan.
http://wiki.apache.org/couchdb/DumpOracleDbToCouchDbPython?action=3Ddiff&re=
v1=3D10&rev2=3D11

--------------------------------------------------

  =3D Dump an Oracle Table to CouchDB using Python =3D
  Since CouchDB requires unique keys to access documents, importing data fr=
om an SQL database is an incitement to deep thought. =

  =

- If you went to the trouble of creating a single unique key in your SQL da=
tabase, you may be inclined to use it as your couchdb _id. Hard to go wrong=
 there. However, for certain groups of documents (say a collection of blog =
posts), simply using a iso format date as your _id is pretty handy and can =
greatly simplify writing views in both Javascript and Python.
+ If you went to the trouble of creating a single unique key in your SQL da=
tabase, you may be inclined to use it as your couchdb _id. Hard to go wrong=
 there. However, for certain groups of documents (say a collection of blog =
posts), simply using an IsoFormattedDateAsDocId is pretty handy and can gre=
atly simplify writing views in both Javascript and Python.
  =

  The first two examples expect a unique key to be extracted from the SQL d=
atabase, the third example lets CouchDB create the unique key. Of the three=
, the first and last are the most useful. The second example is for static =
or "throwaway tables" that have very few values, but might be a pain to jus=
t hand-copy (ex. config data).
 =20