---
title: "Discussion on \"Differences Between SQL And NoSQL Databases\" | Hashnode"
description: "Discussion on \"Differences Between SQL And NoSQL Databases\". Big data, machine learning, and artificial intelligence have brought up issues with data storage. Believe it or not this affects web developers in some interesting ways. The biggest way you could be affected is if end up working with NoSQL databases ..."
url: "https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Differences Between SQL And NoSQL Databases](https://hashnode.com/post/differences-between-sql-and-nosql-databases?utm_source=hashnode&utm_medium=feed)

Big data, machine learning, and artificial intelligence have brought up issues with data storage. Believe it or not this affects web developers in some interesting ways. The biggest way you could be affected is if end up working with NoSQL databases ...

Apr 4, 2019 · hashnode.com  
Updated Apr 9, 2019  
Read the article

-   [#web-development](https://hashnode.com/tag/web-development)
-   [#databases](https://hashnode.com/tag/databases)
-   [#sql](https://hashnode.com/tag/sql)
-   [#nosql](https://hashnode.com/tag/nosql)

## Written by

[Milecia](https://hashnode.com/@flippedcoding)

@flippedcoding

  
[View profile](https://hashnode.com/@flippedcoding)

Mentors new developers | Teaches people un-fluffy code | Tech conference speaker | Super Software Engineering Nerd

Milecia is a senior software engineer, but she also has a master&#39;s degree in mechanical and aerospace engineering and has published research in machine learning and robotics. She started Flipped Coding in 2017 to help people learn web development with real-world projects and it&#39;s being growing ever since. In her free time, she spends time with her husband and dogs while learning to play the ukulele and learning Japanese.

## Responses 3

Markdown supported · ⌘↵ to post

[Edgar](https://hashnode.com/@edgaro)

[Apr 5, 2019](https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b/comment/5ca7a1c69b9404837d3e327e)

You missed other important key differences, NoSQL databases are very good but they have their use case.

-   lack of standardization on NoSQL databases
-   some of them do not support ACID transactions
-   JOINs & aggregations are hard

Also, schema flexibility may be a problem in the future if not handled correctly. I would like to add that query planners for SQL databases are really smart and mature, but I don't know enough about query planners in the NoSQL world to make a comparison.

[Richard Uie](https://hashnode.com/@RichardUie)

[Apr 5, 2019](https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b/comment/5ca70382d71e2d342caff53d)

"In a SQL database, there is a schema that sets the rules for how tables are related to each other."

You may be confusing the notion of schema as it relates to XML documents. Here's a good resource for how IBM DB2 deals with the idea of [Schemas](https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004105.html).

"Rigid, predefined schema that needs to be updated for new columns"

Simple ALTER TABLE operations can ADD (or DROP) columns and would rarely affect or be affected by a schema.

~~~~~~~~~~~~~~~

Days Later Without Reply...

Well all-righty then, since Milecia seems uninclined to correct herself, I will re-emphasize what I said.

Milecia's representations about schemas for RBDMSs are flatly wrong.

Schemas serve very little purpose in RDBMSs other than providing namespace organization for collections of database objects - mainly, they prevent naming collisions and reserve certain organizational ideas, e.g., the SYSIBM schema for DB2.

Columns are not database objects and would only influence or be influenced by schemas, if part or whole of an index (primary or foreign key or performance index...those, not simple columns ARE database objects) came into play, either deleting a column that was part of an index or adding a column that would become part of an index.

Sorry, Milecia, be more careful when you attempt to teach. Especially, don't _teach_ wrong stuff.

[Milecia](https://hashnode.com/@flippedcoding)

[Apr 9, 2019](https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b/comment/5ca70382d71e2d342caff53d#reply-5caca50ae80ebf2f7b830eaf)

Hey [Richard Uie](https://hashnode.com/@RichardUie). Sorry it took a while for me to get back to you because you know, life.

I was talking about the XML documents. I'll have to update it when I get a chance.

Thanks for pointing it out for others! Even teachers screw up sometimes. 🙂

[Milica Maksimović](https://hashnode.com/@mmaksimovic)

[Apr 4, 2019](https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b/comment/5ca6033f43993bd205c52e5b)

Thanks for another writeup [Milecia](https://hashnode.com/@flippedcoding)!

It would be great if you could write about some advantages/disadvantages of both types and which types of projects require which type.

[j](https://hashnode.com/@chilimatic)

[Apr 5, 2019](https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b/comment/5ca6033f43993bd205c52e5b#reply-5ca7067dca43b7bd2b3ae400)

[Edgar](https://hashnode.com/@edgaro) I think you should repost this a normal comment. not as a comment to another comment :)
