NoSQL vs SQL


Woah! I don’t want to start a war guys! Just an honest opinion on the prevailing dilemma(just like Node or Deno 😉 ).

So before I get too deep in it. Let me take this opportunity to first explain what are these Acronyms.

SQL or Structured Query Language  is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

I’ll try it in English this time 😉

Basically your data is stored somewhere and in order to access the data we need some set of instructions. Those specific set of instructions are written in SQL. It allows us to dynamically fetch any stored information as and when required. The important point to remember is that the data is stored in multiple tables. Every data table has multiple rows, individual record or tuple and multiple columns which are fields like age, gender, etc. They are also referred to as attributes.

Here is an image of a SQL database with 1 tuple, i.e., record and 3 fields or attributes, i.e., name, phone, & country.

Whereas NoSQL is Not only SQL. A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.

What it means is that the way the data is stored is entirely different. NO tables, rows or columns exist. Still, the data is being stored. NoSQL databases are document based, key-value pairs, graph databases.

{
  "name": "ThinkWeb India",
  "phone": 9991119991,
  "country": "India",
}

In the above e.g., “name” is the Key & Thinkweb India is the value of the key. It’s the simplest e.g., that I shared.

It’s really not fair to say which one is better, because both have their pros & cons. I’m not getting into those in this blog. However, if you are interested give me a shout-out and I’ll do a in depth article stating the pros & cons of both SQL & NoSQL.

SQL – MySQL, SQL Server, Oracle, SQL Lite, to name some.

NoSQL – Apache CouchDB, Couchbase, MongoDB, Firebase, RethinkDB are a few examples of NoSQL out there.

This was just an attempt to put it out there that both do exist, and both have their specific advantages. Depending on the application’s need a suitable choice should be made.


Follow us on our Official Social Media Platforms.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s