| SQL | NOSQL | |
|---|---|---|
| primarily called relational | non relational | |
| table based | document based | L |
| predefined schema | dynamic schema | |
| vertically scalabel | horizontally scalable |
What kind of data is a good fit for an SQL database? Give a real world example. probably a database of cars that are more complex
What kind of data is a good fit a NoSQL database? Give a real world example. something that is not too complex like a menu at a small burger chain
Which type of database is best for hierarchical data storage? no sql
Which type of database is best for scalability? sql