Tag: SQL

Dates, Timestamps and Timezones – A Comparative study of Oracle and N1QL support for the Date-Time feature : Part 1

Read the pdf version here. Date and Time formats/types are very different for different databases. In the article we shall compare Couchbase N1QL Date-Time functions with Oracle’s Date-Time support. Oracle contains multiple data types associated with date-time support, namely, DATE, TIMESTAMP,...

/ September 22, 2017

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 - licensed through Creative Commons https://commons.wikimedia.org/wiki/File:Spices_of_Sa%C3%BAde_flea_market,_S%C3%A3o_Paulo,_Brazil.jpg

Aggregate grouping with N1QL or with 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...

N1QL

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

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 NoSQL. For example, how do you read and write data with Couchbase Server while...

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

Glass ochem by Purpy Pupple, licensed through Creative Commons https://commons.wikimedia.org/wiki/File:Glass_ochem.png

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, who have recently...

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

Moving Your Node.js with MongoDB Application to Couchbase with N1QL

If you’ve been keeping up with my recent blog articles, you’ll know that I’ve been focusing on the topic of moving applications from MongoDB to Couchbase.  NoSQL is great in modern web applications, but not all NoSQL is created equal...