- Solutions
-
-
Adaptive Applications
Get AI-ready with hyper-personalized apps!
Next level customer experiences require adaptive applications
Learn more
-
-
- Developers
-
-
Capella Playground
-
-
- Resources
-
-
Vector Search
What's Vector Search and why is it important?
Get a quick overview of vectors, vector search, use cases, and key features.
Watch
-
-
Use powerful SQL with Couchbase
SQL++ is SQL for JSON with industry-standard ANSI syntax. SQL++ supports common concepts like ACID transactions, hierarchical schema called scopes, and joins across documents. It also takes advantage of our patented cost-based optimization. Take the tutorial to learn more.
Use SQL++ to overcome tough query challenges
Cost-efficient
Changing queries to a new language is costly. SQL++ meets ANSI 92 standards, which makes migration to Couchbase faster and easier.
Fast
Writing queries can be complex and lead to slow speeds if executed incorrectly. Our cost-based optimizer (CBO) ensures the best performance.
Consistent
Using multiple databases for an application leads to data inconsistency. Couchbase can support all your use cases with a single multi-model database.
Familiar
Learning a new proprietary query language for a database is challenging. SQL++ allows developers to use their existing SQL skills for JSON.
SQL++ key capabilities
SQL++ provides teams with powerful ways to interact with data and develop faster queries to support critical applications.
Global Secondary Indexes (GSI)
GSIs enable low-latency queries for interactive applications. They support collection-level processing.
Indexing innovations
Couchbase includes composite and array indexes and a function that identifies the best index for SQL++ queries.
SQL++: SQL-like queries with the flexibility of JSON
Develop engaging applications with ease using a comprehensive and declarative JSON query language. Developers can rapidly adapt to changing business requirements using a schemaless JSON document store.
Query without compromise, with capabilities you expect from SQL queries
SQL++ is a high-performance NoSQL query language with built-in optimizers and indexer enablers to support millions of concurrent interactions with sub-millisecond latencies. Couchbase’s multi-dimensional architecture uses SQL++ across its query, index, search, and analytics services, partitioning to elastically scale data capacity and deliver accelerated query performance.
Familiar tooling makes query development and optimization a breeze
SQL++ is accessed through the Query Workbench and has a built-in index advice feature that tells the developer what indexes are needed to optimize their query. Flex Index uses the inverted search index from the Full-Text Search Service for complicated query predicates. Couchbase also includes a cost-based optimizer and JavaScript-based user-defined functions to manipulate the resulting data.
What customers are saying
“We quickly realized that Couchbase offers the flexibility to search with a language that looks 99% the same as SQL. So for all developers, it was an easy transition.”
“Within three months, we built a virtual platform to host a conference with over forty thousand attendees. Our partnership with Couchbase made it possible.”
“We extensively use SQL++ for structured querying, and with full-text search we can seamlessly search and derive relevance-based intelligence.”
“We’re able to put data to work in a more efficient way, and we’ve built a strong foundation for the future.”
Couchbase SQL++: The power of SQL meets JSON flexibility
Moving from relational to NoSQL: How to get started from Oracle
Don Chamberlin (SQL inventor) on NoSQL and SQL++
Start building
Check out our developer portal to explore NoSQL, browse resources, and get started with tutorials.
Try Capella
Get hands-on with Couchbase in just a few clicks. Capella DBaaS is the easiest and fastest way to get started.
Try Capella iQ
Use our generative AI-powered coding assistant to create sample data, refine it, and build queries on the datasets.