For the uninitiated, databases come in two varieties:
- Relational databases: These use SQL (with minor variations) for querying the database
- NoSQL databases: These can store unstructured data and use the database specific query language
Relational databases have been around for a long time now, and a lot of effort has been put into optimizing their performance and making them as robust as possible. However, the reliability and performance requires us to plan and organize our data into well-defined tables and relationships. Our data is bound to the schema of the database tables. Anytime we need to add more fields/columns to our table, we will have to migrate the table to a new schema, and this would require us to create migration ...