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 "GaganSaksena" by GaganSaksena
Date Wed, 04 Aug 2010 16:43:22 GMT
Dear Wiki user,

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

The "GaganSaksena" page has been changed by GaganSaksena.
http://wiki.apache.org/couchdb/GaganSaksena

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

New page:
#format wiki
#language en
== Gagan Saksena ==
Some recipes/notes from using CouchDB. These could be valuable someday for others navigating
their way in these waters. For now mostly a placeholder for things I'm learning. This is '''work
in progress'''!

==== Handy shortcuts ====
There are a number of handy shortcuts for doing standard reduce tasks- Checkout [[Built-In_Reduce_Functions]]
for more details.

=== SQL Recipes in Map/Reduce ===
A collection of handy recipes to do common tasks in map/reduce. This page is still in development-
checkout this book's page for some useful details- [[http://books.couchdb.org/relax/reference/views-for-sql-jockeys|Views
for SQL jockeys]]

For the purpose of these recipes- the equivalent SQL table looks like this-

{{{
CREATE TABLE Foo //todo
}}}
||<tablewidth="80%">SQL||Map||Reduce||Notes||

||<tablewidth="80%">SELECT COUNT(*) FROM Foo;||function (doc) {  // todo } ||_count||
||
||SELECT COUNT(*) FROM Foo WHERE Foo.bar ="value";||function (doc) {  //todo } ||_count||Fetch
view with ?key=bar||
||SELECT DISTINCT bar FROM Foo;||function (doc) {  // todo } || || ||
||GROUP BY example||function (doc) {  // todo } || || ||
||GROUP BY with SORT BY example||function (doc) {  // todo } || || ||




----
CategoryHomepage

Mime
View raw message