Databases are used to store data efficiently and securely.
You will hear about different databases like Cassandra, MongoDB, CouchDB etc.
But the two types of DB are
- SQL based - Based on SQL (MySql and PostgreSQL)
- NoSQL based - not based on SQL (MongoDB and Redis)
SQL based (Relational Databases)
- Data is grouped into tables
- Inflexible in some cases (has NULL on all the places where data is missing)
- Structured, Old and reliable
- Requires a Schema
- Scales vertically
NoSQL based (Non-relational databases)
- JSON based storage (Document structure)
- Key value pairs for storing data
- More flexible (Not bound to particular structure)
- Not good with complex relationships with data
- Scales horizontally
- Shiny and New
Thanks for reading
Top comments (0)