New ask Hacker News story: Ask HN: Is NoSQL Still the Wave?
Ask HN: Is NoSQL Still the Wave?
5 by MathCodeLove | 4 comments on Hacker News.
Are NoSQL DB's like Mongo or Dynamo still popular and viable options for a database? It seemed as if a year ago everyone was advocating for them. I see less of that now, but I don't see anyone giving me a legitimate reason not to use them either.
5 by MathCodeLove | 4 comments on Hacker News.
Are NoSQL DB's like Mongo or Dynamo still popular and viable options for a database? It seemed as if a year ago everyone was advocating for them. I see less of that now, but I don't see anyone giving me a legitimate reason not to use them either.
Full disclosure: I work for NoSQL database provider ScyllaDB. The answer is that both SQL and NoSQL databases are successful doing different things for different use cases. If you were doing a corporate ERP system? A bank system? Stick with an RDBMS. However, if you were trying to do customer profiles for tens of millions of people for a social media app? A real-time malware detection app for millions of different pieces of email and web transactions per day? You'd be better off with NoSQL. Of the top 10 databases on DB-engines.com, SQL systems account for the top 4, and 7 of the top 10. And those rankings have barely changed in a year. Which means that NoSQL isn't about to supplant SQL any time soon for its core business, but then again, people are not abandoning NoSQL to return to some bucolic, nostalgic only-SQL shop.
ReplyDeleteThe main thing is: use the database that best supports your use case. If you have complex data models that require normalization? Tables that need to be joined in complex ways? Stick with SQL. If you have denormalized data, sparse data, or complex connections (more complex than simple table joins can model), then need a key-value, a wide column, a document database or a graph database. Use the right tool for the right data domain. Don't force fit your queries or your data model to a vanilla all-cases system. Use hammers and nails where appropriate. Use screws, nuts, bolts, glue, tape, clamps or other forms of connective methods for other cases. Don't pretend that, just because you have a hammer that everything's a nail.