SQL Vs NoSQL
Welcome back! I’ve been making a ton of articles going into detail of the programming languages used at top companies, a lot of comments wanted me to understand the differences between these two query languages, so let’s talk about what the main differences are between these languages. First off, NoSQL is not a variation of SQL, they both live independent to one another.
What is the difference?
The main difference between these two languages is: SQL databases are relational where NoSQL databases are built non-relational, what does this mean? Well, a relational database stores data which are related to one another, a good example of this is found on Omnisci.com:
You can see that the id variable is used in multiple different databases, essentially linking the database tables together. Non-relational databases are essentially the opposite of this, essentially the tables within the database have no correlation to one another, they’re pretty much just storing the data into a database.
On top of those points, the structure of these database are a little bit different as well. SQL databases are scaled vertically, NoSQL databases are scaled horizontally, what does this…