Query This Couchbase Database on Linux

Access the server's web UI at http://publicip:8091 and set the Administrator user's password.

Note: Please wait an extra minute or two before trying to connect to http://publicip:8091 to allow the lab to fully provision.

Create a new bucket named demo-bucket:

/opt/couchbase/bin/couchbase-cli bucket-create -c 127.0.0.1:8091 --username Administrator --password Omgpassword! --bucket demo-bucket --bucket-type couchbase --bucket-ramsize 512

First, connect to the Couchbase Query console (CBQ):

/opt/couchbase/bin/cbq -e http://localhost:8091 -u=Administrator

Use INSERT INTO to insert data:

INSERT INTO `demo-bucket` ( KEY, VALUE ) Values ( "doc0",{"name": "David", "department": "Engineering"} ) RETURNING META().id as docid, *;
INSERT INTO `demo-bucket` ( KEY, VALUE ) Values ( "doc1",{"name": "Clay", "department": "HR"} ) RETURNING META().id as docid, *;
INSERT INTO `demo-bucket` ( KEY, VALUE ) Values ( "doc2",{"name": "Sue", "department": "Sales"} ) RETURNING META().id as docid, *;
INSERT INTO `demo-bucket` ( KEY, VALUE ) Values ( "doc3",{"name": "Betty", "department": "Marketing"} ) RETURNING META().id as docid, *;

In order to query the data, an index is required:

CREATE PRIMARY INDEX `demo-index` ON `demo-bucket`;

Once the index is created, you can query the data:

SELECT * FROM `demo-bucket` WHERE name= "Betty";
UPDATE `demo-bucket` set department = "Sales" WHERE name= "Betty";