Understanding NoSQL databases
Two of the most common places to store data are in a Relational Database Management System (RDBMS) such as SQL Server, PostgreSQL, MySQL, and SQLite, or in a NoSQL database such as Azure Cosmos DB, Redis, MongoDB, and Apache Cassandra.
Relational databases were invented in the 1970s. They are queried with Structured Query Language (SQL). At the time, data storage costs were high, so relational databases were designed to reduce data duplication as much as possible. Data is stored in tabular structures with rows and columns that are tricky to refactor once in production. They can be difficult and expensive to scale.
NoSQL does not just mean “no SQL”; it can also mean “not only SQL”. NoSQL databases were invented in the 2000s, after the internet and the web had become popular and adopted many of the learnings from that era of software.
They are designed for massive scalability, high performance, and to make programming...