Tag: SQL

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/...

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:...

October 26, 2017
Oracle Date Format: N1QL and Support for Date-Time Functions

Oracle Date Format: N1QL and Support for Date-Time Functions

Date and Time functions and formats can vary for different databases. In this article, we shall compare Couchbase ISO-based Date-Time functions with Oracle Date format. Date formats vary between relational and NoSQL database due to the nature of NoSQL JSON...

September 22, 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,...

September 7, 2017
Aggregate grouping with N1QL / MapReduce

Aggregate grouping with N1QL / MapReduce

Aggregate grouping is what I’m titling this blog post, but I don’t know if it’s the best name. Have you ever used MySQL’s GROUP_CONCAT function or the FOR XML PATH('') workaround in SQL Server? That’s basically what I’m writing about...

August 22, 2017
Bringing SQL to NoSQL – Rich, Declarative Querying for JSON

Bringing SQL to NoSQL – Rich, Declarative Querying for JSON

Couchbase Server is a document-oriented NoSQL database. Most NoSQL systems force you to sacrifice the rich querying capabilities of SQL in trade for the other benefits they offer. At Couchbase, we’ve developed the N1QL query language to solve this problem....

Getting Started with NoSQL Using Couchbase Server and PHP

Getting Started with NoSQL Using Couchbase Server and PHP

A few days ago I wrote about using PHP with Docker and Couchbase, but I never really got into best practices of going all in with PHP and NoSQL databases. For example, how do you read and write data with...

A Comparison of SQL and NoSQL to Simplify Your Database Decision

A Comparison of SQL and NoSQL to Simplify Your Database Decision

Have you been investing your time, effort, and resources in building ETL procedures that keep migrating data from one database to another? Is your RDBMS fully equipped to deal with unstructured and non-traditional data? With Big Data becoming the hottest...

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...

April 13, 2017
Working with Arrays in Couchbase with N1QL – Video Tutorial

Working with Arrays in Couchbase with N1QL – Video Tutorial

In a recent article, I wrote about flattening and querying arrays in Couchbase using N1QL.  That article was inspired by a popular question in the Couchbase Forums.  After publishing the article, I felt a write-up alone couldn’t do it justice...

N1QL: A Practical Guide

N1QL: A Practical Guide

N1QL is designed to help developers easily develop applications to solve real-world problems.  Technically, N1QL is designed to give developers and enterprises an expressive, powerful, and complete language for querying, transforming, and manipulating JSON data. N1QL takes inspiration from SQL...

March 17, 2017