DEV Community

RohitrajDeshmukh
RohitrajDeshmukh

Posted on

SQL vs NO-SQL

What is SQL?

SQL Stands for Structured Query Language is a standardized programming language that's used to manage relational databases and perform various operations on the data in them.
SQL is used to communicate with a database.
You can easily create and manipulate the database, access and modify the table rows and columns, etc.
Examples of SQL MySQL, Oracle, SQL Server, PostGre, etc.

Advantages of SQL:

  • High-Speed Query Processing
  • Standardized Language
  • Portability
  • More than one Data View

What is NO-SQL?

NoSQL databases are non-tabular databases and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. The main types are document, key-value, wide-column, and graph. They provide flexible schemas and scale easily with large amounts of data and high user loads.
Examples of NoSQL are MongoDB, DynamoDB, Cassandra, etc.

Advantages Of NO-SQL:

  • Flexible schemas
  • Horizontal scaling
  • Fast queries due to the data model
  • Ease of use for developers

SQL vs NO-SQL



       SQL                     vs                NO-SQL

1.SQL is a relational                1.No-SQL is a non-relational
database management system.            or distributed database 
                                         management system.

2.The query language used            2.The query language used in 
in this database system is            the No-SQL database systems
a structured query language.           is a non-declarative query 
                                         language.

3.The schema of SQL databases        3.The schema of No-SQL Data-
 is predefined, fixed,                 base is a dynamic schema
 and static.                            for unstructured data.

4.It follows the ACID model.         4.It follows the BASE model.

5.These databases are vertically     5.These databases are 
 scalable.                              horizontally scalable.

6.The database type of SQL           6.The database type of No-
is in the form of tables, i.e.          SQL is in the form of 
in the form of rows and columns.        document key-value, and 
                                              graphs.

7.Complex queries are easily         7.NoSQL databases cannot 
 managed in the SQL database.           handle complex queries.

8.All SQL databases require          8.Many No-SQL databases do 
object-relational mapping.              not require object- 
                                          relational mapping.

9.This database is not the           9.No-SQL database is a 
 best choice for storing               perfect option for storing 
 hierarchical data.                      hierarchical data.

10.SQLite, Ms-SQL, Oracle,          10.Redis, MongoDB, Hbase, 
PostgreSQL, and MySQL are              BigTable, CouchDB, and 
examples of SQL database systems.      Cassandra are examples of 
                                        NoSQL database systems.
Enter fullscreen mode Exit fullscreen mode

Top comments (2)

Collapse
 
rahulvijayvergiya profile image
Rahul Vijayvergiya

Nice article.
I have discussed relational databases (SQL), document stores, key-value stores, column-family stores, graph databases, time-series databases, in-memory databases, and multi-model databases, exploring when and why each is ideal for different applications.
If your are interested to know more - dev.to/rahulvijayvergiya/choosing-...

Collapse
 
salehmubashar profile image
Saleh Mubashar

Thanks!
Pls check out my posts too
Thanks