DEV Community

Cover image for Database introduction for Newbie Web Developers
Sakshi
Sakshi

Posted on

Database introduction for Newbie Web Developers

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

  1. SQL based - Based on SQL (MySql and PostgreSQL)
  2. 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)