couchdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Couchdb Wiki] Update of "DumpOracleDbToCouchDbPython" by DougShawhan
Date Fri, 25 Feb 2011 17:23:25 GMT
Dear Wiki user,

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

The "DumpOracleDbToCouchDbPython" page has been changed by DougShawhan.
http://wiki.apache.org/couchdb/DumpOracleDbToCouchDbPython?action=diff&rev1=10&rev2=11

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

  = Dump an Oracle Table to CouchDB using Python =
  Since CouchDB requires unique keys to access documents, importing data from an SQL database
is an incitement to deep thought. 
  
- If you went to the trouble of creating a single unique key in your SQL database, 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 database, 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 greatly simplify writing views in both Javascript and Python.
  
  The first two examples expect a unique key to be extracted from the SQL database, 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 just hand-copy (ex. config data).
  

Mime
View raw message