CouchDB is one of those databases that is super simple to get started with and then has its not so obvious “tricks” how to accomplish things that might have felt super natural in another DB. Now, first lets pause right here and think of what I just said: > …might have felt super natural in another…
Daniel Wertheim
Quick and basic tip about how you can partition dates in your map and use that as an array key and then use different group-level values to perform aggregation on different granularity. Given that we have some simple documents representing sales: POST /sales/_bulk_docs {"docs":[ {"_id": "1", "c…
Daniel Wertheim
Thought we could take a quick look at how to do a SQL'ish starts with LIKE 'Prefix%' query in CouchDb, using startkey, endkey & inclusive_end. Given a couple of simple documents: { "_id": "m1", "_rev": "...", "v": "a" } { "_id": "m2", "_rev": "...", "v": "ab" } { "_id": "m3",…
Daniel Wertheim