Questions tagged [couchbase]

Use for Couchbase Server or Couchbase Capella only (NOT CouchDB or Couchbase Lite). Couchbase Server is a distributed database engineered for performance, scalability, availability and flexible query. It enables developers to build applications easier and faster with both the power of SQL and the flexibility of JSON.

Capella is Couchbase's DBaaS (Database-as-a-Service). It is fully managed, hosted, patched, and upgraded by Couchbase.

Developed as an alternative to traditionally inflexible SQL databases, the Couchbase NoSQL database is designed to help developers solve real-world problems and meet high scalability demands along with unparalleled performance.

Developer features

  • Enhance application development agility by capitalizing on a declarative query language, full-text search, adaptive indexing, and seamless data mobility full-text search, adaptive indexing, and seamless data mobility
  • Achieve fast, efficient bi-directional synchronization of data from the edge to the cloud and between clusters
  • Build seamless data sharing across users and devices – online and offline
  • Consistent programming model for building web and mobile apps

Couchbase is designed to help enterprise applications perform well (up to 10-20x faster than competition) while also scaling to match data volumes. The use of in-memory datasets allows you to process and optimize queries and indexing processes. Coupled with the features of Couchbase Mobile, applications can continue to operate even in offline mode.

Management Tools

  • Streamline configuration and setup, take advantage of multi-cloud agility
  • Built-in enterprise-grade security for the full stack
  • Easily enable cross datacenter replication between clusters through a convenient UI

Useful links

3998 questions
1
vote
2 answers

Get binary document from QueryResult Couchbase response

I am using Couchbase 3.2 SDK, to query couchbase server. Like below QueryResult result = cluster.query( "SELECT *, Meta().id FROM bucketName USE KEYS ?", …
best wishes
  • 5,789
  • 1
  • 34
  • 59
1
vote
2 answers

Couchbase N1QL - Trying to perform join operation between two documents in couchbase query editor but not getting any result

Couchbase - N1QL query I'm trying to join two documents within same bucket and have to perform GroupBy "DepartmentName" and count on "TeamMemberID" whose "TerminalCheckinStatus" is "COMPLETED" **First Type of Document** docstore { DepartmentName:…
Maulik Sakhida
  • 471
  • 4
  • 15
1
vote
2 answers

N1QL (CB6.6) ANSI merge

I am trying to fetch customer id from ":ao.mos:pro:%" and update corresponding doc ":pd:pro:%", we have thousands of ":ao.mos:pro:%" docs and corresponding ":pd:pro:%" for each mo:pro doc. I am using below query and it works but it updates only one…
1
vote
1 answer

Couchbase N1QL Update complex-structured JSON document

Intro Hi! After using Spring Startup Actuator endpoint, I recieved the data about steps my application took to start. It's a JSON response, and I'd like to modify it a little, to make it more readable. Since I use CouchBase in my project, I though…
Philipp Ytkin
  • 55
  • 1
  • 8
1
vote
1 answer

N1QL Couchbase update properties on nested object where key is dynamic

How to update all properties active to false if key of object is a number: { "id": 1, "items": { "2": { "id": 2, "active": true }, "3": { "id": 3, "active": true }, "5": { "id": 5, …
Framer
  • 13
  • 3
1
vote
0 answers

Couchbase Bulk Get documents using Reactive Flux

I am trying to bulk get documents using Reactive to improve the performance. Its working fine but it's intermittently giving empty result. I am passing list of ids which contain 100 id's per request. I am using Couchbase 6.6 and SDK 3.1.2 and java…
1
vote
1 answer

n1ql.delete not working in spring data couchbase

I am using spring data couchbase and I want to write a custom query for deleting all the docs based on some condition I have below query written down: @Query("#{#n1ql.delete} WHERE #{#n1ql.filter} AND " + "accountId = $1 #{#n1ql.returning}") …
user3553913
  • 373
  • 3
  • 17
1
vote
1 answer

update an object inside couchbase document using CBQ console

I have a document like below { "runs": { "run1": { "result": "pass", "state": "success" }, "run2": { "result": "fail", "state": "incomplete" } } } How can I add…
Naveen K
  • 11
  • 2
1
vote
0 answers

how to solve the problem "requestTooBigException" when using add in couchbase?

I use couchbase to be the cache, when I put one key-value,it throws an RequestTooBigException.do you know how to figure out.please tell me if you know, thanks a bunch. Sorry, I can't provide the code because this problem appears in my company's…
Meng XU
  • 11
  • 2
1
vote
1 answer

Spring Data Couchbase with @Query and Pageable / Sort throwing ArrayIndexOutOfBoundsException - PagingAndSortingRepository, CouchbaseRepository

I am trying to execute custom query with @Query annotation which is connecting to couchbase and I am expecting paging response. I have code like below Controller import org.springframework.data.domain.Page; import…
1
vote
1 answer

Requested resource not found when trying to query from cli

I'm trying to perform some queries on a couchbase database through curl command. According to the documentation I was able to get info about a specific bucket using: curl -v http://base.example.com:8091/pools/default/buckets/results -u…
J. Doe
  • 619
  • 4
  • 16
1
vote
1 answer

couchbase Expression must depend only on group keys or aggregates

why I get this error message on my query ? "Expression (`L`.`product_id`) must depend only on group keys or aggregates. Query: SELECT P.product_id as PID, L.product_id as LikedPID, COUNT(L.likedAt) as likes FROM products P INNER JOIN…
localdata01
  • 587
  • 7
  • 17
1
vote
0 answers

couchbase I am doing to set index on the right place?

I am puttin the index on the right place ? I want to index from a document the product_id. CREATE INDEX `index_product_id` ON `products` (product_id) USING GSI; I want to index this field: (product_id) { "**product_id**": "32132", "rating": 5, …
localdata01
  • 587
  • 7
  • 17
1
vote
1 answer

How to make CouchBase sub-query with RAW MAX , execution faster

I have this query: "SELECT meta(d).id as ID, meta(d).cas as CAS, d.* " +"FROM (SELECT RAW MAX([t.eventTimestamp, META(t).id])[1] " +"FROM `xyz` as t " +"WHERE t.`docType` = '" +docType.toString() + "' " +predicates +"GROUP…
skunwarc
  • 33
  • 5
1
vote
1 answer

Couchbase maximum permissible query length

This question is especially in the context, when we have IN clause in the query, and number of elements in the in clause can be dynamic and huge as per the application needs.
Madhav Kumar Jha
  • 353
  • 1
  • 2
  • 13