Category: N1QL / Query
FTS and N1QL: Improving Performance when Querying Multiple Arrays
Introduction Couchbase Full Text Search (FTS) is a great fit for indexing multiple arrays and executing queries with multiple filter predicates in arrays. In this article, I’ll demonstrate the advantages of using FTS over GSI (Global Secondary Index) for array...
Couchbase for Oracle Developers — Part 4 : Data types
Link to the series home page: https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/ As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types...
SQL to NoSQL – 7 Metrics to Compare Query Language
Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model. Learn a new API/Query to access the...
Part 2: N1QL: To Query or To Analyze?
When you need to query documents using SQL, there are two options available in Couchbase. The Query service and the Analytics service. Our blog, N1QL: To Query or To Analyze? provides a detailed overview of both services. I highly recommend...
Fullstack React and GraphQL : Apollo Client
Third of three articles focused on building Fullstack React and GraphQL with the Apollo GraphQL Client. Setting up a NoSQL Couchbase Server (Part 1) Building an Express-GraphQL API (Part 2) Create Apollo GraphQL Client in React (Part 3)) Final Source...
Fullstack React and GraphQL : Express Server
Second of three articles focused on building Fullstack React and GraphQL with Express and Couchbase Server. Setting up a NoSQL Couchbase Server (Part 1) Building an Express-GraphQL API (Part 2) Create Apollo GraphQL Client in React (Part 3) Final Source...
Fullstack React and GraphQL : Couchbase
First of three articles focused on building Fullstack React and GraphQL with Express and Couchbase Server. Setting up a NoSQL Couchbase Server (Part 1) Building an Express-GraphQL API (Part 2) Create Apollo GraphQL Client in React (Part 3) Final Source...
IN List Handling Improvements in Couchbase Server 6.5
Introduction IN list is commonly used in N1QL queries. Couchbase Server 6.5 introduces a couple of enhancements in handling of IN list in N1QL queries. Handling of Large IN List Before Couchbase Server 6.5 N1QL handles IN list evaluation at...
Index Advisor Service for Couchbase N1QL(Feb refresh)
This is our Feb drop for Index Advisor service after fixing some of the bugs that were found. We plan to keep improvising the Index Advisor service(What is it?). The fixes in Index Advisor that you would normally see in...
Announcing Couchbase Server 6.5 GA – What’s New and Improved
We are pleased to announce the release of Couchbase Server 6.5 GA with stellar features that lead the innovation in the NoSQL database market. We are excited to once again pioneer some of the most sought-after relational capabilities in the...