Book Image

Learning Couchbase

By : Henry Potsangbam
Book Image

Learning Couchbase

By: Henry Potsangbam

Overview of this book

This book achieves its goal by taking up an end-to-end development structure, right from understanding NOSQL document design to implementing full fledged eCommerce application design using Couchbase as a backend. Starting with the architecture of Couchbase to get you up and running, this book quickly takes you through designing a NoSQL document and implementing highly scalable applications using Java API. You will then be introduced to document design and get to know the various ways to administer Couchbase. Followed by this, learn to store documents using bucket. Moving on, you will then learn to store, retrieve and delete documents using smart client base on Java API. You will then retrieve documents using SQL like syntax call N1QL. Next, you will learn how to write map reduce base views. Finally, you will configure XDCR for disaster recovery and implement an eCommerce application using Couchbase.
Table of Contents (12 chapters)
Index

Indexing properties


Querying an unindexed property causes the server to scan the entire bucket and check that property on every document. You can create indexes with the following syntax:

CREATE INDEX Index_name
ON LearningCouchbase(name)

Here, Index_name is the name of the index you want to create, LearningCouchbase is the name of the bucket, and name is the attribute of documents in which you want to create the index.

Note

One thing you need to remember is that you cannot execute any N1QL query until you create a primary index with the query shown next.

CREATE PRIMARY INDEX ON LearningCouchbase

Views

When you create indexes on a bucket; internally, Couchbase creates views on your behalf. As shown in the preceding screenshot, you can find views in the view editor after you create indexes.

Explaining a query

Sometimes, we like to know how queries will be executed in the Couchbase cluster. It helps us to tune it while in the development phase. You just need to append the EXPLAIN keyword before...