SQL vs NoSQL: What’s The Difference?

SQL

Pros

  • Due to having a predefined schema table, data can be accessed really fast because we would know exactly what row or column to manipulate any data.
  • Been in use with programming for decades, which offers great community knowledge and support.
  • SQL follows the ACID properties making the data very accurate and easy to navigate in the DB.

Cons

  • It has drawbacks with scaling, since you would have to redefine the database scheme if you want to add something simple such as a user’s favorite color or some other random data that you might have to assign in the future.
  • Can be troublesome converting data objects with correct data due to placement of database rows & columns
  • Just not very user friendly in my opinion, SQL as a language wasn’t too hard to learn but the clunky interfaces that DB companies offers, are just not very good.

NOSQL

Pros

  • Great with scaling, due to being able to create and manipulate data freely in an unstructured way thus being able to add more attributes to data along the way.
  • You can start creating a database without having to predefine a scheme structure, which is great in my opinion.
  • Very flexible since it isn’t confined by rows or column, NoSQL store data in “documents” which each can have it’s own properties and attributes.

Cons

  • Not great for complicated queries since the document format is less structured compared to traditional SQL schema tables.
  • NoSQL is becoming more and more popular these days but it still lacks the community support that SQL can offer due to years in practice.
  • Can become costly once it scales and the file system becomes too big if you aren’t properly handling the duplication of data.

When to use each

Conclusion

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Steven Wu

Steven Wu

I’m a NYC based full stack developer and a part-time gaming nerd https://www.linkedin.com/in/stevenwubc/