Review of JSON Databases

Loading

This article looks at the data models of JSON databases.


Most databases now support JSON, but that does not mean that their data model is good for your application.  let us review the candidates. 

Relational Databases

MySQL, etc store data in tables.  Very limiting

PostgreSQL

Postgress is fundamentally a relational model.  It has the nice feature that some tables can inherit their data structure from another table.  Better than the normal relational model, but still not very interesting. 

Key Value Databases

CouchBse is a key value database, where the values can be JSON documents.  Here is their data modeling page. Better than the relational databases. 

CouchDB is another key value JSON database. 

MongoDB

Mongo DB gives you collections of JSON documents.   Collections are an improvement over CouchBase.

 

CouchDB