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,…
-
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…
-
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…
-
JSON is Case Sensitive. You Don’t Have to Be.
A RoSe by any other case would smell as sweet. William Shakespeare You must have learned capitalization rules in your grammar school, but the real-world search is not so sensitive to capitalization. Charles de…
-
It’s SQL. Again.
— In the spirit of Alexander Pope and Sir John Squire.
-
Primary Uses for Couchbase Primary Index
A couple of frequently asked questions on N1QL for query service: Read on… Couchbase is a distributed database. It supports flexible data model using JSON. Each document in a bucket will have a user-generated…
-
Cost Based Optimizer for Couchbase N1QL (SQL for JSON)
Authors & Engineering Team: Bingjie Miao, Keshav Murthy, Marco Greco, Prathibha Bisarahalli. Couchbase, Inc. A rule-based optimizer knows rules for everything and cost for nothing – Oscar Wilde Abstract Couchbase is a distributed JSON…
-
Searching JSON: compare text search in Couchbase and MongoDB.
“Apps without search is like Google homepage without the search bar.” It’s hard to design an app without a good search. These days, it’s also hard to find a database without a built-in search.…
-
Using YCSB to Benchmark JSON Databases
Bruce Lindsay once said, “There are three things important in the database world: Performance, Performance, and Performance”. Most enterprise architects know, as we progress in database features and architectures, it’s important to measure performance in an…
-
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…
-
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…
-
Database Pagination: Using OFFSET and Keyset in N1QL
Read the pagination background in my previous article: https://www.couchbase.com/blog/optimizing-database-pagination-using-couchbase-n1ql/ Pagination is the task of dividing the potential result into pages and retrieving the required pages, one by one on demand. Using OFFSET and LIMIT…