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.https://o1.qnsr.com/log/p.gif?;n=203;c=204663295;s=11915;x=7936;f=201904081034270;u=j;z=TIMESTAMP;a=20410779;e=i
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.