Couchbase SDKs and SQL commands

Couchbase SDKs and SQL commands

Couchbase SDKs support all of the four standard SQL commands used for reading and writing data. These functions in Couchbase have different method names, but they are the functional equivalents of the following SQL commands:

SQL Command Couchbase SDK Method
INSERT , to create. set and add
SELECT , to retrieve/read data. get , multiple-retrieves, and get-and-touch (get and update expiration).
UPDATE , to modify data. set with a given key, or add with a new key, or replace with a key, or cas , also known as compare and swap. Used to update a value by providing the matching CAS value for the document. There are also methods for incrementing and decrementing numeric values, changing the expiration for a value, as well as pre-pending or appending to stored objects.
DELETE , to remove data. delete , deletes information associated with a given key.