Summit 2014: Postgres + JSON - the best of both worlds? / Hadar Davidovich
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 considerations
We will also briefly cover PostgreSQL’s JSON support, and describe some best practices we’ve adopted for using it.