Category: SQL++ / N1QL Query

Introducing FTS with N1QL
Topics this article will cover What’s good with N1QL? What about FTS? But why FTS within N1QL? Basic N1QL+FTS queries Deploying N1QL+FTS Syntax(es) Abilities & limitations N1QL+FTS Internals Covered-index vs Non-covered-index queries More N1QL+FTS query examples What’s next? 1. Couchbase’s...

Deep Dive: Window functions in Couchbase Analytics
Couchbase Server 6.5 brings a host of new features [1] to the leading NoSQL database. One of the key additions to the N1QL query language is support for window functions. These functions were originally introduced in the SQL:2003 standard and provide...

Running FTS Queries in N1QL
We already discussed how the Like % clause is potentially harmful for your application at scale, and why you should consider using Couchbase Full-Text Search instead. One thing we haven’t mentioned yet is why you might prefer Couchbase FTS over any...

Infosys “OpenHack” Development Program Features Couchbase
Senior architects from Couchbase and Infosys played the role of “master hacks” mentoring and reviewing various solutions from the 5 week "OpenHacks" event.

Less Is More: Why Use a Cost-Based Optimizer?
Couchbase includes a cost-based optimizer (CBO). Learn how having a CBO improves query performance and how to implement it.

Analytics Explain Plan – Part 1
Co-author: Till Westmann, Senior Director, Engineering Introduction Couchbase Analytics is the “newest kid on the block” amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to...

It’s SQL. Again.
[crayon-68e3c5159e0a3452550912/] [crayon-68e3c5159e0a8752924207/] — In the spirit of Alexander Pope and Sir John Squire.

Primary Uses for Couchbase Primary Index
What is the Couchbase Primary Index? The primary index scan provides you with the “full table scan” equivalent for all the documents from start to finish.

Index Advisor For Query Workload
Overview As the second feature of Index Advisor released in Couchbase server 6.5 (Developer Preview), Advisor function extends the scope from advising on single query to providing index recommendations for query workload and support on session handling. In this article,...

Window functions in Couchbase Analytics
Co-author: Till Westmann, Senior Director, Engineering The bits for Couchbase 6.5, the upcoming release of Couchbase Server, are now available. The Analytics service, which supports efficient parallel query processing, has added support for support for window functions defined in the...

Advanced Filtering with XDCR 6.5
Customers use XDCR for various use cases from high availability to data locality to disaster recovery to cloud migration and hybrid cloud deployments. To meet these use cases, there are a number of circumstances where they would want to replicate...

Index Advisor for N1QL Query Statement
Overview Index advisor is introduced in Couchbase server 6.5 as a developer preview feature. It targets at providing secondary index recommendation to help DBAs and developers optimize N1QL query performance. This version is rule-based, in which the index candidates will...
Top Posts
- New Enterprise Analytics Brings Next Generation JSON Analytics to...
- How I Built a Plant RAG Application with Couchbase Vector Search...
- Integrate Groq’s Fast LLM Inferencing With Couchbase Vector...
- Couchbase Introduces Capella AI Services to Expedite Agent Develo...
- MongoDB Ends Mobile Support Today: Migrate to Couchbase
- Data Analysis Methods: Qualitative vs. Quantitative Techniques
- Capella Model Service: Secure, Scalable, and OpenAI-Compatible
- What are Embedding Models? An Overview
- Securing Agentic/RAG Pipelines with Fine-Grained Authorization