Différences

Ci-dessous, les différences entre deux révisions de la page.

--- informatique:nosql [30/10/2012 12:29] – cyrille
+++ informatique:nosql [30/10/2012 15:20] (Version actuelle) – cyrille
@@ Ligne 7: / Ligne 7: @@
 Une liste de serveurs et d'outils NoSQL sur la page [[/informatique/sgbd#sgbd_nosql|informatique/sgbd sgbd_nosql]]
+Doc:
+  * An [[http://guide.couchdb.org/draft/cookbook.html|NoSQL's View cookbook for SQL jockeys]]
+  * [[http://wiki.apache.org/couchdb/View_Snippets|View Snippets]]
+  * The [[http://blog.mudynamics.com/wp-content/uploads/2009/04/icouch.html|interactive CouchDB simulator]]
+Discussions:
   * 2009-06 [[http://www.developpez.net/forums/d773158/bases-donnees/decisions-sgbd/sgbd-mouvement-anti-sql-s-amplifie/#post4458431|SGBD : le mouvement anti-SQL s’amplifie ?]]
+En vrac:
+  http://localhost:5984/boamp/_design/resumes/_view/byLieu?key="75"
+<code>
+// The Map function "titles_by_posted_at" :
+// Get all article titles ordered by posted date.
+function(doc) {
+  if(doc.type == 'article') {
+    emit([doc.posted_at], doc.title);
+  }
+}
+// Query :
+//  GET /blog/_articles/titles_by_posted_at
+// Result:
+{
+"total_rows":75,
+"offset":0,
+"rows":[
+  {"id":"2157b289eed2fe4512326698fd114d2f","key":["2007-12-15T20:14:02Z"],"value":"Showing multiple message types with the flash"},
+  {"id":"2157b289eed2fe4512326698fd0de8b3","key":["2007-12-20T14:50:41Z"],"value":"Class, Instance and Singleton methods"},
+  // ... and so on ...
+}
+// Query for a key :
+//  GET /blog/_articles/titles_by_posted_at?key=["2007-12-20T14:50:41Z"]
+// Query for a start and end key :
+//  GET /blog/_view/articles/titles_by_created_at?startkey=[%222007-12-01T00:00:00Z%22]&endkey=[%222007-12-31T24:00:00Z%22]
+</code>