A Crash Course in NoSQL vs SQL

If you like this article, you’ll love the SQL!

Audience

Argument

Schema vs No Schema

An example relational model
An example of using a graph, we can traverse from TV Show A to a different TV show which shares similar features.
Row vs Column

Vertical vs Horizontal Scaling

Approaches to CAP and PACELC

Complexity of Queries

MATCH (:Person {name: 'James'})-[:PRESENTED]->(programme:Programme)
RETURN programme
Programme example
A potential single table design

ACID vs BASE

When to Use

NewSQL, the shape of things to come…

Conclusion

Principal Software Engineer at the BBC