SQL++: ANSI SQL for JSON
SQL++ is Couchbase’s powerful database language that combines structured query language (SQL) with the flexibility of JavaScript Object Notation (JSON). Meeting the American National Standards Institute (ANSI) syntax guidelines and designed for developers, SQL++ allows you to leverage existing skills to build modern applications with speed, consistency, and efficiency
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.
Use SQL++ to overcome tough database language challenges
Cost-efficient
Changing queries to a new language is costly. SQL++ meets ANSI 92 standards, which makes SQL 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 skills in ANSI SQL for JSON.
SQL++: SQL-like queries with the flexibility of JSON
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.
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.”
Fidencio Garrido, Principal Engineer, DirecTV38M+
customers
3K+
channels
-
“What Couchbase has done with SQL++ has been one of the most innovative things done in the database space in decades.”
Bill House, VP of Engineering, SWARM Engineering400%
faster planning
3-10X
ROI for customers
-
“We extensively use SQL++ for structured querying, and with full-text search we can seamlessly search and derive relevance-based intelligence.”
Dave Starling, CTO, Seenit92%
faster implementation for new feature
100+
stores
-
“We’re able to put data to work in a more efficient way, and we’ve built a strong foundation for the future.”
Arvind Jade, Architect Lead, Nielsen80%
increased change management efficiency
50%
boost in response time
Explore related resources
-
DATASHEET
Couchbase SQL++: The power of SQL meets JSON flexibility
-
WHITEPAPER
Moving from relational to NoSQL: How to get started from Oracle
-
VIDEO
Don Chamberlin (SQL inventor) on NoSQL and SQL++