View my GitHub profile

enriquein's blog

My blog. Or my attempt at maintaining one.

Hybrid SQL and NoSQL models with PostgreSQL - Part 2: The data model

In this post I’ll be writing about the database model and also show some examples of the types of operations we’ll be doing on our JSON data. This post is the second part of a series, so you will probably want to read the previous post first. Continue reading…

Hybrid SQL and NoSQL models with PostgreSQL - Part 1: An introduction

In this series I’m going to be covering the use of PostgreSQL as a hybrid between a traditional SQL relational model and a document-based NoSQL model. First I’ll cover the database side of things, and then I’ll go into how I implemented data access from an application written in C#.

But first, some context. Continue reading…