SQL vs NoSQL
A SQL database keeps data in linked tables with fixed rules. A NoSQL one uses other shapes, like documents or keys, and has looser rules.
Relational Database
A database that keeps data in linked tables. You talk to it in SQL.
A relational database keeps data in tables that link to each other through keys. Each table holds one kind of thing, and keys tie a row in one table to rows in another. You ask it questions in SQL. It checks the rules you set, so the data stays correct. PostgreSQL, MySQL and SQLite are all relational databases.
NoSQL Database
A database that does not use linked tables. It keeps data in other shapes.
A NoSQL database stores data in some shape other than linked tables. Some store documents, some store keys and values, and some store graphs of linked points. Most do not need a fixed schema, so each record can look a bit different. Many are built to spread across lots of servers. MongoDB and Redis are two well-known examples.
In one line
- Relational Database
- A database that keeps data in linked tables. You talk to it in SQL.
- NoSQL Database
- A database that does not use linked tables. It keeps data in other shapes.