SQL and NoSQL differences

Database classification

one, SQL database:mysql

SQL Cons:

1, in many cases, timely access, is not necessary.

2, a lot of things need

3, consumption performance.

Two, NoSQL database:redis,mongodb

Gave up 3 points.

1, real-time consistency.

2, things

3, multi-table joint query.

MongoDB feature 1, no data structure limitations

A, without the concept of a table structure, each record can have a completely different structure
B, business development is convenient and quick.
The C,sql database needs to implement a definition table structure and reuse it.

2, full index support
Single-piece index,
Array index,
Full-Text indexing,
Location Index

3, easy to expand
Replication sets ensure data security
Shard Scale Data size

　　

SQL and NoSQL differences