Category: Data Modeling

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

Handle Data Modeling Errors in a Golang with Couchbase Application

I’ve been developing with Couchbase and the Go SDK for a while now, but recently I ran into an issue that I deemed to be a bug in the SDK after hours of troubleshooting. I was trying to execute a...

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

Persist and Abstract Data in a Nativescript Typescript Application

Couchbase is a great tool to persist data inside our app. If you haven’t heard of it, it’s a document object storage that allows you to save your data. If you are using NativeScript-Angular, there are already some great tutorials...

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

Sample application

Sample Application with Spring and Angular: GitTalent

One of the first big projects I was involved in after I started at Couchbase last year was helping to create a sample application that would be demonstrated at Couchbase Connect 2016. Sample application It was an enormous team effort...

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

FakeIt Series 4 of 5: Working with Existing Data

FakeIt allows you to provide existing data to your models through JSON, CSV or CSON files. This data is exposed as an inputs variable in each of a models *run and *build functions.

FakeIt Series 3 of 5: Lean Models through Definitions

Definitions are a way of creating reusable set(s) within your model. It allows you to define a set of properties / values one time, referencing them multiple times throughout your model. Definitions in a FakeIt model are very similar to...

FakeIt Series 2 of 5: Shared Data and Dependencies

There are tons of random data generators available, a simple Google Search will give you more than enough to choose from. However, almost all of these have the same frustrating flaw, which is they can only ever deal with a...