DEV Community

Rajdeep Ray
Rajdeep Ray

Posted on

SQL vs NoSQL Databases

sqlvsnosql

SQL

  • Relational database management system (RDBMS)
  • These databases have fixed or static or predefined schema
  • These databases are not suited for hierarchical data storage.
  • These databases are best suited for complex queries
  • Vertically Scalable
  • Example - MySQL, PostgreSQL, Oracle

NoSQL

  • Non-relational or distributed database system.
  • They have dynamic schema
  • These databases are best suited for hierarchical data storage.
  • These databases are not so good for complex queries
  • Horizontally scalable
  • Example - MongoDB, Cassandra, Redis

Top comments (0)