In the shift towards NoSQL DBs (let it be document based, key-value, or column-oriented to touch a few) it is quite common to forsake some hard-learnt lessons and best practices from the relational databases domain.

In this session, we will discuss some common data related dilemmas when scaling up server side applications, and explain why we choose to use PostgreSQL’s JSON support over MongoDB in order to scale up.

We will touch on various considerations when choosing the most suitable database solution for our need, such as:

Data migrations, schema upgrades, forward and backward compatibility considerations

We will also briefly cover PostgreSQL’s JSON support, and describe some best practices we’ve adopted for using it.

MP3