Category: SQL++ / N1QL Query
-
A Comparison of 3 NoSQL Query Languages Across 7 Metrics
Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: Some also find the confusion with the NoSQL name. The abbreviation stands for…
-
Running FTS Queries in N1QL
We already discussed how the Like % clause is potentially harmful for your application at scale, and why you should consider using Couchbase Full-Text Search instead. One thing we haven’t mentioned yet is why you…
-
Infosys “OpenHack” Development Program Features Couchbase
Couchbase is expanding its partnerships with industry-leading global systems integrators and regional solution providers. Through these partnerships, Couchbase’s unique capabilities can be delivered to our global footprint of enterprise customers. We collaborate closely with…
-
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…
-
Comparing Postgres JSONB With NoSQL
The reality is that databases are converging, and in the last few years, it is becoming even more difficult to point what are the best scenarios for each datastore without a deep understanding of…
-
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.…
-
N1QL & SEARCH: Leverage Full-Text Search (FTS) Index in N1QL
With Couchbase v6.5, Full-Text Search is now integrated into the Couchbase N1QL query construct. Customers can now leverage FTS indexes directly with N1QL. This provides developers a single API to combine N1QL exact predicate…
-
NDP Episode #24: Brant Burnett on Linq
Linq is the focus of the latest episode of The NoSQL Database Podcast. Brant Burnett joins as the special guest to talk about all things Linq and Linq with NoSQL. I’m also joined by…
-
YCSB-JSON: Implementation for Couchbase and MongoDB
YCSB is a great benchmarking tool built to be easily extended by any driver which supports and implements basic operations like: insert, read, update, delete and scan. Plain synthetic data introduced by YCSB fits this…
-
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…