DEV Community

Cover image for Intro to my Professional Self Via The Differences Between SQL and NoSQL
Chris Kiser
Chris Kiser

Posted on • Updated on

Intro to my Professional Self Via The Differences Between SQL and NoSQL

Who am I?

Hello, and welcome to my first class assignment for IST 210 at Penn State University!

As you could probably already tell I am a student attending Pennsylvania State University. I am currently a sophomore studying in IST. My plan is to graduate with a degree in Cybersecurity Analysis and Operations.

Carrer plans
As of now, I have no clue what I want to do with my degree, but hey I have until 2023 to figure it out... I am however looking for ideas every single day!

My Brand

currently unknown
At the time of writing this (my first blog post), I don't currently have a brand name/personality thought of. This is something that I may be seen as for the rest of my life, so I want to take my time and really decide how I want to portray myself as I continue my college career and pursue life. So, for now, I will go by Chris.

Differences Between SQL and NoSQL

First off, we have to talk about what SQL and NoSQL are:

SQL :
The Structured Query Language, or SQL, is a domain-specific language, or DSL, used to interact with relational databases and relational data streams.
NoSQL :
NoSQL is a database that facilitates the storage and retrieval of data. Commonly used for applications that require horizontal scaling, like real-time web applications, it relies on a non-SQL low-level query language to store and retrieve data.

There are many differences, but to keep my first post not too long I will briefly mention just a couple of main differences.

  • Amounts of Adoption

SQL: Widely adopted - basis for several popular procedural extensions.

NoSQL: Less adopted - Has to do with the limitations NoSQL presents.

  • ACID Transactions (atomicity, consistency, isolation, durability)

SQL: SQL is ideal for situations where databases, regardless of where they sit, need ACID.

NoSQL: Not all NoSQL databases have true ACID transactions.

Additional Links:
SQL vs NoSQL
Youtube Video SQL vs NoSQL
What is ACID?

Top comments (0)