SQL vs NoSQL: That Is the Query
SQL vs NoSQL: That Is the Query
A compendium of DZone's best articles on the subject of SQL vs. NoSQL over the past decade, how the argument has evolved, and who's winning the argument.
Join the DZone community and get the full member experience.Join For Free
SQL vs NoSQL: Time for Some Introspection
In this post, we look at the long and storied history of the SQL vs NoSQL debate. The articles included stretch way back to the ancient days of the early 2010s and go through 2019 — each exploring a different aspect of the SQL vs NoSQL quandry.
After all these years duking it out, is either solution winning the battle for developers' hearts and minds?
SQL vs NoSQL: The Early Times
- (2011) SQL vs NoSQL in the Cloud: Which Database Should You Choose? by Avi Kapuya. A discussion of how the different access patterns provided by NoSQL and SQL result in very different scalability and performance.
- (2012) SQLfying NoSQL: Are ORM Tools Relevant to NoSQL? by Amresh Singh.
- (2013) What Is NoSQL? by Eric Gregory. An OG article on the ideas behind non-relational databases. Take a look at the conepts that started the epic SQL vs NoSQL battle.
- (2013) Relational Databases vs NoSQL Tradeoffs for Startups by Eric Genesky. A databases expert discusses the SQL vs NoSQL debate and what these technologies each bring to the unique challenges of startups.
- (2014) When to Use MongoDB Rather Than MySQL (or Other RDMBS): The Billing Example by Moshe Kaplan. NoSQL has been a hot topic a pretty long time. However, when should we really use it instead of an RDBMS?
- (2015) SQL, NoSQL, and the Future of Databases by John Esposito. In the future (as of 2015), SQL databases may give way to more distributed models while NoSQL and Hadoop vie for the top spot.
- (2015) MySQL Is a Great NoSQL Database by Aviran Mordo. At Wix engineering, we’ve found that in most cases we don’t need a NoSQL database, and that MySQL is a great NoSQL database if it’s used appropriately.
(2016) SQL vs NoSQL by Prashanth Jayaram. Take a look at the differences in the battle between SQL vs NoSQL databases. And remember, make your DB decision based on the project, not on the hype.
(2016) SQL vs NoSQL vs NewSQL: Comparative Advantages and Disadvantages by Vika Klochkova. Looking to adopt a database? What do you choose? SQL? NoSQL? How about NewSQL? See how each system stacks up against the other in this high-level overview.
(2016) Relational vs NoSQL Databases for API Traffic by Vineet Joshi. Take a look at the priorities and pros and cons of SQL and NoSQL when it comes to dealing with API traffic.
SQL vs NoSQL: 2017
A Comparison of SQL and NoSQL to Simplify Your Database Decision by Laura Czajkowski. Learn what SQL is, what NoSQL is, the key differences that highlight the SQL vs NoSQL conflict, and whether you should be using SQL or NoSQL when implementing your ETL processes.
SQL or NoSQL, That Is the Question! by Alon Brody. No one path, SQL vs NoSQL, is right for all scenarios, so when it comes to ACID compliance, indexing, and scalability, choose both options to cover all uses.
MongoDB vs MySQL by Mihir Shah. Look at MongoDB vs MySQL in terms of schema flexibility, relationships, performance, speed, security, and more.
Why We Moved From NoSQL MongoDB to PostgreSQL by Avi Cavale. Learn why one dev team decidecd to make the switch from a NoSQL to a SQL database, and how it affected the project.
Database: 2017 Suprises and 2018 Predictions by Tom Smith. Given how fast technology is changing, we decided to ask IT executives to share their thoughts on the biggest surprises in 2017 and their predictions for 2018. How'd we do with these predictions?
SQL vs NoSQL: 2018
NoSQL vs SQL: Differences Explained by John Hammink. This article looks at the differences between SQL vs NoSQL. Explore an overview of SQL/RDBMS, NoSQL, and types of NoSQL databases.
[DZone Research] SQL or NoSQL, That Is the Question by Jordan Baker. Apologies for accidentally stealing your title Mr. Brody. A discussion of data taken from the 2018 DZone Guide to Databases, focusing on the data related to who developers use SQL databases and NoSQL databases.
NoSQL vs Relational Databaes: When to Use What by Rajat Mehta. This article explores the key differences between NoSQL and relational databases, and delves into how NoSQL databases scale horizontally.
The Types of Modern Databases by John Hammink. Consider the pros and cons of SQL, RDBMS, relational databases, NoSQL, and non-relational databases.
Database 2018 Surprises and 2019 Predictions by Tom Smith. This in-depth article looks at database surprises from 2018 and predictions for 2019 from IT executives. How have these predictions faired?
MongoDB vs RDBMS by Kunal Sethi. This article includes a comparison between MongoDB and RDBMS, and one person gives his opinion and several examples of why MongoDB is superior to RDBMS.
Why Is Oracle and Microsoft SQL Adoption Low on AWS? by Kevin Goldberg. This article looks at why Oracle and Microsoft SQL adoption is low for developers on AWS, how public cloud growth impacts database market share, and the effect of the SQL vs NoSQL debate on the industry.
SQL vs NoSQL: 2019
Is SQL Beating NoSQL? by Ajay Kulkarni. In this post, we examine why the pendulum today is swinging back to SQL and what this means for the future of the data engineering and analysis community.
The Unreaonable Effectiveness of SQL by Keshav Murthy. Let's see what made SQL great and why it's still so popular and powerful as NoSQL databases gain in popularity.
Why You Should Use Relational Databases Instead of NoSQL for Your IoT Applications by Diana Hsieh and Matthew Perry. This post explores why using relational databases instead of NoSQL for IoT applications is important, as it can allow data to be accessed by multiple users.
Redis vs MySQL Benchmarks by Ayush Jain. A developer performs a comparative study on the performance of Redis (NoSQL) and MySQL (SQL) databases, providing all the code you'll to run your own tests.
How to Choose the Right Database Among Cassandra, MongoDB, and MySQL for Your Applications by Gazanfur Ali Mohammed. See how to choose the right database for your applications between the SQL and NoSQL options Cassandra, MongoDB, and MySQL.
Facebook's User DB: Is it SQL or NoSQL? by Karthik Ranganathan. A developer takes a look at Facebook's user database, exploring whether it is a SQL or NoSQL database.
2019 Open Source Database Report by Kristi Anderson. Take a look at the state of databases, including a special glance at how open source databases are performing against commercial counterparts.
Relational to NoSQL: CRM Application Data Visibility by Binh Lee. In this article, see how the activity management model can be best represented in JSON.
Comparing Postgre JSONB With NoSQL by Denis W. S. Rosa. A developer takes a comparative look at the SQL database Postgre, and its JSONB datatype, and NoSQL databases.
Approaches to Query Optimization in NoSQL by Keshav Murthy. A comparative look at SQL and NoSQL database optimization and how to apply the lessons learned to MongDB code.
Opinions expressed by DZone contributors are their own.