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.
Changing queries to a new language is costly. SQL++ meets ANSI 92 standards, which makes SQL migration to Couchbase faster and easier.
Writing queries can be complex and lead to slow speeds if executed incorrectly. Our cost-based optimizer (CBO) ensures the best performance.
Using multiple databases for an application leads to data inconsistency. Couchbase can support all your use cases with a single multi-model database.
Learning a new proprietary query language for a database is challenging. SQL++ allows developers to use their existing skills in ANSI SQL for JSON.
SQL++ provides teams with powerful ways to interact with data and develop faster queries to support critical applications.
GSIs enable low-latency queries for interactive applications. They support collection-level processing.
Couchbase includes composite and array indexes and a function that identifies the best index for SQL++ queries.
MDS delivers workload isolation of various microservices so you can scale out the service you need when you need it.
Built-in language-aware text searching enables users to quickly obtain the most relevant documents based on scoring.
Develop engaging applications with ease using a comprehensive and declarative JSON query database language. Developers can rapidly adapt to changing business requirements using a schemaless JSON document store.
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.
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.
“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.”
“What Couchbase has done with SQL++ has been one of the most innovative things done in the database space in decades.”
“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.”
Check out our developer portal to explore NoSQL, browse resources, and get started with tutorials.
Get hands-on with Couchbase in just a few clicks. Capella DBaaS is the easiest and fastest way to get started.
Want to learn more about Couchbase offerings? Let us help