How should one store date in Couchbase? So far, I have come across two options. I will discuss their relative merits here.
In this tutorial we will learn the basics of developing a Java application using Couchbase.
In SQL, we do SELECT COUNT(*) to count rows that match a query criteria. In Couchebase, we use the _count reduce. In this article, I will explain two most common use cases for counting documents.
The atomic counter feature of Couchbase has been discussed extensively. But, a few crucial issues seem to have been glossed over. Most tutorials, such as this, as well as the official document, go as follows:
- Step 1 – Initialize the counter.
- Step 2 – Increment the counter.
There are a few crucial issues left out in this discussion. You are likely to encounter these issues on day one if you try to use atomic counter in a real application. I hope this post will answer those questions for you.
Take these steps to quickly install Couchbase 2.2.0 in Ubuntu server 13.04.
DB2 has various tools that will show you how it goes about executing a SQL statement. I like the db2expln tool. It also calculates a relative cost of operation for every SQL statement. You can use that to compare the performance of two alternative statements.