Learn N1QL with Real Code Examples

N1QL queries executed by Couchbase Query Service

Indexes created and managed by the Index Service

Data stored as JSON documents in Buckets

Distributed execution across nodes

Integrated with Analytics, Search, and Eventing services

N1QL query parsed and optimized

Planner selects index

Query executed across cluster nodes

Results streamed back to client

Document-oriented modeling

Use JOINs strategically

Array indexing for nested JSON

Analytics via separate service

Session store for high-throughput apps

E-commerce product catalogs

Real-time analytics dashboards

Gaming leaderboards and inventories

SQL power on JSON

Distributed execution

Flexible schema

High-performance indexing

Add nodes for horizontal scaling

Distribute indexes across Index nodes

Use replicas for availability

Optimize queries with array indexes

Migrate from SQL via similar syntax

Convert relational joins to document joins

Create proper indexing strategy

Monitor performance with EXPLAIN