Thursday, September 23, 2021

Difference between SQL and No SQL

 SQL: 

    If Schema doesnt change

    Pros- Normalization and Joins

    Cons- Usually its hosted server in machines


No SQL:

    Scaling is easy

    Schema not defined

    High load Json schema 

    Consistency not checked

1. Your application requires super-low latency

2. Data are unstructured or you do not have any relational data.

3. You only need to serialize and deserialize data JSON, XML or YAML.

4. You  need to store a massive amount of data.


No comments:

Post a Comment

Comment!!

Lauki pizza at home

  Try this low carb healthy lauki pizza at home. Lauki Pizza Recipe - 1. Lauki 1 2. Oats flour 1/2 cup 3. Parmesan cheese grated 1/4 cup 4. ...