Differences in designing and integrating a SQL database versus a NoSQL database in your application

In this section, we will review the differences between SQL and NoSQL databases, examine how the new latter type of database varies from the traditional model, and consider when it is recommended to use each of them.

SQL versus NoSQL databases

Structured Query Language (SQL) allows the access and manipulation of information in a relational database. When we talk about a SQL database, we mean that SQL is used on that particular database.

NoSQL, on the other hand, means not only SQL, indicating that this type of database provides more flexible schemas and structures than those found in traditional databases.

If we make a connection with the two types of databases reviewed in the previous section, Cloud SQL corresponds to a service that allows us to manage databases such as MySQL, PostgreSQL, and SQL Server—databases that use SQL to perform inquiries about stored information...