In the family of NOSQL stores there is a particular family, focusing on storing semi-structured data as ONE unit called a document. This family is called: “document stores. It’s most often represented by a JSON-blob. When it comes to ACID-compliance, it’s “guaranteed” for ONE document. Either it acc…
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":[ {&quo…
Daniel Wertheim
MyCouch is the simple asynchronous CouchDb [http://couchdb.org] and Cloudant [http://cloudant.com] client for .Net – building on top of the asynchronous HTTP client and uses JSON.Net to provide flexible serialization behaviour. It is distributed via NuGet(CouchDb package [https://www.nuget.org/packa…
Daniel Wertheim
It's a well known fact that you shall not use only skip and limit to achieve pagination in CouchDb. How-ever, since v1.2 of CouchDb, things has apparently become a bit better [https://issues.apache.org/jira/browse/COUCHDB-1076], but is skip and limit without the need of startkey good enough for…
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&q…
Daniel Wertheim