Databases

Question 1

SQL vs NoSQL

Answer 1

SQL
Structured Query Language
Most Popular
MySQL
PostgreSQL
NoSQL
Not Only Structured Query Language
Most Popular
MongoDB
Redis

Question 2

Differences

Answer 2

1. Structure
SQL
Table Format, kind of like a Excel Sheet
Missing cells, will contain Null
Consistent Structure
NoSQL
JSON Object structure
Flexible Structure

Question 3

2. Relationships

Answer 3

SQL
Relational
Good for many-to-many relationships
Can have multiple tables, and we can link a relationship between them
Will lead to less repetitive data
NoSQL
Non-Relational
Can lead to repetitive data
Good for 1-to-many type relationships

Question 4

3. Scalability

Answer 4

SQL
Becomes slower with more rows of data
NoSQL
Better for scalability