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:

• ACID compliance Vs. eventual consistency models
• When does it make sense to use document databases?
• Best practices for defining your documents scope
• Implications on the programming model – object oriented vs. service oriented
• Data migrations, schema upgrades, forward and backward compatibility considerationsWe will also briefly cover PostgreSQL’s JSON support, and describe some best practices we’ve adopted for using it.

MP3