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).
  

Reply via email to