Tag: JSON

JSON Data Modeling for RDBMS Users

JSON Data Modeling for RDBMS Users

JSON data modeling is a vital part of using a document database like Couchbase. Beyond understanding the basics of JSON, there are two key approaches to modeling relationships between data that will be covered in this blog post. The examples...

Matthew Groves January 25, 2018
Couchbase for Oracle Developers – Part 2 : Architecture

Couchbase for Oracle Developers – Part 2 : Architecture

Back in November, Raju Suravarjjala, (Sr. Director, Couchbase QE & Performance) and I  presented “Mindmap: Oracle to Couchbase For Developers”. You can see the slide deck here: http://bit.ly/2mPdJfo. Overview article for the series is at is at https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/. This series is written in...

Keshav Murthy January 22, 2018
Introducing Full Text Search (FTS) in Couchbase Mobile 2.0

Introducing Full Text Search (FTS) in Couchbase Mobile 2.0

Couchbase Mobile 2.0, introduces powerful Full Text Search (FTS) capabilities on your JSON Documents. This is part of the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you are familiar with SQL,...

Database Pagination: Using OFFSET and Keyset in N1QL

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 is the easy way to write...

Keshav Murthy January 11, 2018
Introducing the Query Interface in Couchbase Mobile 2.0

Introducing the Query Interface in Couchbase Mobile 2.0

The Couchbase Lite 2.0 Release, brings a plethora of new features and enhancements. We discussed one such enhancement, namely the new replication protocol between in an earlier blog post on Replication 2.0. In this blog post, we will introduce you...

Optimizing Database Pagination using Couchbase N1QL.

Optimizing Database Pagination using Couchbase N1QL.

Background: How does Google do it? When you google something or anything, it gives you back top relevant results, tells you an approximate number of documents for your topic — all under a second.   Here are some high-level pointers: https://www.google.com/search/howsearchworks/algorithms/...

Keshav Murthy November 2, 2017
N1QL: A Practical Guide. Second Edition

N1QL: A Practical Guide. Second Edition

Two years and two weeks ago, on a crisp fall day at Wall Street in New York, we launched N1QL in Couchbase 4.0. Even before the launch, we had customers using pre-release N1QL because it solved the critical business problem:...

Keshav Murthy October 26, 2017
Pagination in Couchbase Server with N1QL and PHP

Pagination in Couchbase Server with N1QL and PHP

Onwuka Gideon is a freelance full stack developer with years of experience designing and coding web applications and solving complex problems. He loves security, writing, and discussing new technology. When building applications that deal with a large number of documents,...

Learn N1QL in 10 Minutes: An Interactive Online Tutorial

Learn N1QL in 10 Minutes: An Interactive Online Tutorial

N1QL is SQL for JSON. The goal of N1QL is to give developers and enterprises an expressive, powerful, and complete language for querying, transforming, and manipulating JSON data. The goal of N1QL is to give developers and enterprises an expressive,...

Keshav Murthy September 7, 2017
Converting XML to JSON In C# Using Json.NET

Converting XML to JSON In C# Using Json.NET

Converting XML to JSON data that can be loaded into Couchbase Server can be accomplished with a little bit of .NET. Depending on the source of the data, you might be able to use a tool like Talend. But you...

Matthew Groves July 6, 2017
Data Modeling NoSQL Documents in MongoDB vs Couchbase Server

Data Modeling NoSQL Documents in MongoDB vs Couchbase Server

When I’m out at events, I get a lot of questions regarding the differences between MongoDB and Couchbase Server as they are both in the NoSQL space and are both document databases. One particular question is related to data modeling....

SQL to JSON Data Modeling with Hackolade

SQL to JSON Data Modeling with Hackolade

SQL to JSON data modeling is something I touched on in the first part of my “Moving from SQL Server to Couchbase” series. Since that blog post, some new tooling has come to my attention from Hackolade, which has recently...

Matthew Groves April 13, 2017