NoSQL
-
CAP
-
easier to scale
-
favour high availability - eventual consistency
-
better for lack of data schema
-
is the structure known? or access/query patterns
-
scalability/latency
SQL:
- ACID
- more about consistency
- harder to scale but still possible using sharding/partioning
- modelled at tabular
- Normalised data