Tag: SQL
Search & Rescue: 7 Reasons N1QL Developers Use Search
People don’t want a four key index. They need a four-ms response. Ted Levitt Application development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering,...
Keshav Murthy
April 22, 2019
The Unreasonable Effectiveness of SQL
Two score and five years ago two young IBM researchers brought forth on databases, a new language, conceived in relational, dedicated to the proposition that data can be manipulated declaratively and easily. In the years since Don Chamberlin and Ramond...
Keshav Murthy
April 2, 2019
JSON to Insights: Nobel Prize Winners dataset.
Nobel prizes are announced over a week in October and the award ceremony is today, December 10th (“It’s already tomorrow in Australia”). There is an interesting story of the how C. V. Raman (of Raman effect) booked his ticket to...
Keshav Murthy
December 9, 2018
JSON to Insights: Fast and Easy
Co-author: Sitaram Vemulapalli, Principal Engineer, Couchbase R&D. “The answer my friend is hiding in JSON” – Bob Dylan There are a lot of public JSON datasets and then is awesome JSON datasets. Every company, including yours, has stored a lot of...
Keshav Murthy
December 1, 2018
On Par with Window Functions.
Use golf analogy when explaining to executives. Use a car analogy for all others. — Confucius. The purpose of window functions is to translate the business reporting requirements declaratively and effectively to SQL so query performance and developer/business-analyst efficiency improve...
Keshav Murthy
November 22, 2018
Using N1QL with Couchbase Eventing Functions.
Now, this is not the end. It is not even the beginning of the end. But it is, perhaps, the end of the beginning. — Winston Churchill Updating data is usually not the end, but usually a progress of a...
Keshav Murthy
October 20, 2018
The Couchbase Data Platform in Action: Analytics
Contents What is CBAS and how does it compare to “standard” Couchbase? Example Data and Configuration Code and Queries Web Client Web Server and Queries Querying with SQL++ Query Optimization Query Results and REST Response Conclusion Postscript With the release...
Hod Greeley, Developer Advocate, Couchbase
August 22, 2018
Changes to the Couchbase Analytics Service
Contents 6.0 Data Definition Language Postscript The Couchbase Analytics Service uses the SQL++ query language. SQL++ is an modern query language designed to work with semi-structured data and the JSON data model. SQL++ is backwards-compatible with SQL. The Coucbase Analytics...
Hod Greeley, Developer Advocate, Couchbase
August 21, 2018
How to Join JSON: Couchbase N1QL vs. MongoDB Query
As NoSQL databases evolved, each added higher level APIs or languages to help programmers to complex things easily. SQL, having done that for relational data, showed the way. In SQL, developers say WHAT needs to be done and the database...
Keshav Murthy
July 11, 2018
A Guide to N1QL features in Couchbase 5.5: Special Edition
N1QL was first released with Couchbase 4.0 in the fall of 2015. After two and a half years, it’s great to release Couchbase 5.5 and this N1QL 5.5 feature booklet with it at the New York Couchbase Connect. This special...
Keshav Murthy
May 10, 2018
Divide and Conquer: Couchbase GSI Index partitioning.
In Couchbase, data is always partitioned using the consistent hash value of the document key into vbukets which are stored on the data nodes. Couchbase Global Secondary Index (GSI) abstracts the indexing operations and runs as a distinct service within...
Keshav Murthy
April 11, 2018
Understanding Index Grouping And Aggregation in Couchbase N1QL Query
Couchbase N1QL is a modern query processing engine designed to provide aggregate SQL for JSON by index on distributed data with a flexible data model. Modern databases are deployed on massive clusters. Using JSON provides a flexible data mode. N1QL...
Sitaram Vemulapalli
April 3, 2018