Pain is often the stimulus behind innovations. This is particularly true in software development, in what we endearingly call Pain Driven Development (PDD). Starting from the 1980s, we have all known how to handle relational data – simply put it in a Relational DataBase Management System (RDBMS) and use SQL to work with the data. For the past few years however, our industry has seen an increasing trend towards the usage of NoSQL databases, where data just isn’t stored like in relational databases.

Yes, thousands of internet debates are dedicated to the SQL vs NoSQL fight. But does it have to be a fight? If you are choosing one over the other, do you know for sure why and what the potential benefits of each are? This article is a run-down of most common benefits and pitfalls of both SQL and NoSQL approaches, including simple comparisons and developer to developer considerations. There is no right or wrong; as usual, the classic answer stands true – it depends.

Full article HERE.