Author
GenAI: A New Tool in the Developer Toolbox
Developers craft software that both delight consumers and deliver innovative applications for enterprise users. This craft requires more than just churning out heaps of code; it embodies a process of observing, noticing, interviewing, brainstorming, reading, writing and rewriting specifications; designing,...
Keshav Murthy
November 19, 2023
NoSQL Is Dead, Long Live NoSQL
Dynamo accelerated the NoSQL revolution that’s driving the database industry. Recently, Amazon announced PartiQL – A SQL-Compatible Query Language for their flagship NoSQL database Amazon DynamoDB. This has brought the NoSQL “re:evolution” full circle. It’s wonderful to see the collaborative research from UCSD and...
Keshav Murthy
December 16, 2020
Halloween Problem: Solution in N1QL.
Learning SQL is easy; Implementing SQL, not so much. Halloween has come and gone. But, the tricks of the Halloween problem is here to stay! This has to be solved by databases every day. SQL made the relational database easy,...
Keshav Murthy
November 3, 2020
N1QL Transactions : Elastic, Scalable, and Distributed
SQL is the only 22nd-century language available for developers today. ABSTRACT In relational database systems, SQL is more than a declarative query language. It includes procedural language (T-SQL, PL/SQL, etc) and defines transactions and its semantics. SQL as a query...
Keshav Murthy
October 14, 2020
Arrays in JSON: Modeling, Querying and Indexing Performance
Array is THE difference between the relational model and the JSON model. — Gerald Sangudi Abstract JSON array gives you flexibility in the type of elements, number of elements, size of the elements, and the depth of the elements. This...
Keshav Murthy
August 4, 2020
Comparing MongoDB MQL with N1QL features in Couchbase 6.5
This is a short note reviewing the MongoDB MQL language features highlighted in the release blog: MongoDB 4.4: User-Driven Engineering. Ready for You. MongoDB 4.4 release has added a number of features for the MQL language. Couchbase released 6.5 earlier...
Keshav Murthy
July 31, 2020
FIRST CLASS SQL for FULL-TEXT SEARCH
Over time, the database industry has realized full-text search and SQL are two sides of the same coin. Text search needs further query processing, query processing needs text search to efficiently filter for text patterns. The SQL databases have added...
Keshav Murthy
July 7, 2020
Analyze This: MongoDB & Couchbase Analytics.
The purpose of computing is insight, not numbers. — Richard Hamming The spiral of running the business, analyzing what to change & what to change to, and then changing the business is an eternal one. Do the right analysis, your...
Keshav Murthy
June 23, 2020
Example Architectures for Data Intensive Applications.
…a drawing should have no unnecessary lines and a machine no unnecessary parts. —William Strunk Jr., Elements of Style In the book Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems, Martin Kleppmann has written about traits...
Keshav Murthy
June 14, 2020
Couchbase Intro for MongoDB Developers and NoSQL Experts
Six thousand years ago, the Sumerians invented writing for transaction processing — Gray & Reuter By any measure, MongoDB is a popular document-oriented JSON database. In the last dozen years, it has grown from its humble beginnings of a single...
Keshav Murthy
April 25, 2020
Flexible Query & Indexing for Flexible JSON Model.
Use N1QL when you’re in a JSON pickle. — Confucius For the JSON data model, the advice is to think of collections as tables, JSON document as denormalized rows and field names as columns – roughly. All this holds in...
Keshav Murthy
April 13, 2020
Couchbase for Oracle Developers – Part 4 : Data types
Link to the series home page: https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/ As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types...
Keshav Murthy
March 25, 2020