SQL Databases
Relational Databases
Relational Databases store data in a tabular way. Each column represents a property/attribute of the data that can be stored in the table. Each row is an actual entry/record that is currently stored in the table.
| id | apartment | city_id | rent | sq ft | deadline | has gym | ... |
|---|---|---|---|---|---|---|---|
| 0 | Lorem | 23 | $1500 | 1234 | 2023-1-1 | false | ... |
| 1 | Ipsum | 0 | $2000 | 1100 | 2022-12-1 | true | ... |
| id | city_name | population | ... |
|---|---|---|---|
| 0 | Dolor | 2m | ... |
| ... | ... | ... | ... |
| 23 | Sit | 345k | ... |
When to use Relational?
Relational is ideal when your data can be conveniently stored in the form of tables. You know ahead of time how many columns you need and the data type of each column.
On the other hand, if you expect your data structure to change frequently, a NoSQL Database may be a better fit. NoSQL provides better flexibility in handling semi-structured and unstructured data.
SQL
SQL – Structured Query Language – is a widely-used standard for storing, manipulating and retrieving data in a relational database.