Category: SQL++ / N1QL Query
Relational to NoSQL – CRM Application Data Visibility
As a follow up to my previous webcast on the subject of Relational to NoSQL database where I discussed that we are in the third phase of the NoSQL database adoption, the “Broad Replatforming” of Enterprise Application. I want to provide...
Binh Le
January 21, 2019
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. MySQL to NoSQL, Sybase to Couchbase,...
Keshav Murthy
December 21, 2018
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 matching and FTS powerful searching. The...
Binh Le
December 11, 2018
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: Analyzing US healthcare Data.
“Nothing is certain except for death and taxes.” This isn’t a dataset made with a bed of roses or manicured green grass. A bit more serious. Let’s see if we can quickly learn anything here. The dataset is the following. “name”...
Keshav Murthy
December 7, 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
Connecting to Couchbase via ODBC
Couchbase Analytics Couchbase Data Platform now supports hybrid transaction/analytical processing (HTAP) workloads. Plus, our massively parallel processing (MPP) query engine lets users run ad-hoc analytical queries that deliver faster insights without impacting performance. Couchbase Analytics reduces the time to insight...
Sachin Smotra, Director Product Management, Couchbase
November 27, 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
It’s the Workload, Stupid!
As an application architect, eventually, you’d have to choose the database or database as a service (DBaaS) to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier. The use cases were roughly...
Keshav Murthy
November 14, 2018
Announcing Couchbase Server 6.0 with Analytics
We are proud to announce that Couchbase Server 6.0 is now available, with the central theme of helping reduce the time to insight from enterprise applications. As part of this release, Couchbase Analytics service is now officially available. After two...
Sachin Smotra, Director Product Management, Couchbase
October 31, 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
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 special co-host Jeff Morris, an engineer...
Matthew Groves
October 12, 2018