Couchbase Enables SQL to Run Against JSON Document Database

Mike Vizard
Slide Show

Five Reasons Scale-Out SQL Will Make Waves in the Enterprise

At the Couchbase Connect 2015 conference today, Couchbase revealed that it has developed an implementation of SQL that can be applied to a document database based on the JavaScript Object Notation (JSON) data format.

While document databases have gained a lot of momentum among developers, from the perspective of database administrators (DBAs) in the enterprise, they represent something of a headache because they don’t support SQL.

Ravi Mayuram, senior vice president of products and engineering for Couchbase, says the project complements SQL++ technology developed by the University of California, San Diego (UCSD) and is currently in beta along with version 4.0 of the Couchbase database. The N1QL: SQL for JSON (Nickel) project makes it possible to apply SQL queries to Couchbase in much the same way SQL is used to query every other database in the enterprise.

Mayuram says Couchbase is betting that IT organizations would rather standardize on a document database that supports SQL than use rival platforms that don’t. As IT organizations become more comfortable with having to support multiple types of backend databases, Mayuram notes that the one unifying layer of software that can span all those environments is SQL.

Longer term, SQL support for JSON document databases should go a long way toward healing a schism that has developed between developers and DBAs. Developers have embraced document databases because they are simple enough for them to stand up without requiring the help, or even permission, of a DBA. But the bigger issue from an enterprise IT perspective is that up until now, document databases were only really addressable using JavaScript. Of course, it may take a little while for all the parties involved to forgive and forget. But SQL support inside a JSON document database is certainly a major step in the right direction.


Add Comment      Leave a comment on this blog post

Post a comment





(Maximum characters: 1200). You have 1200 characters left.



Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.