<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/when-to-use-sql-vs-nosql-mwipbejry" -->

---
title: When to use SQL vs NoSQL | daily.dev
description: Choosing between SQL and NoSQL databases can be daunting. SQL excels in data consistency and complex querying, while NoSQL offers scalability and flexibility....
canonical: https://daily.dev/posts/when-to-use-sql-vs-nosql-mwipbejry
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: When to use SQL vs NoSQL | daily.dev
og:description: Choosing between SQL and NoSQL databases can be daunting. SQL excels in data consistency and complex querying, while NoSQL offers scalability and flexibility....
og:url: https://daily.dev/posts/when-to-use-sql-vs-nosql-mwipbejry
og:image: https://api.daily.dev/og/posts/mWIPbejRY.png
og:image:alt: When to use SQL vs NoSQL
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# When to use SQL vs NoSQL

**[DEV](https://daily.dev/sources/devto)** · 4 min read · 166 upvotes · 2 comments

## Summary

Choosing between SQL and NoSQL databases can be daunting. SQL excels in data consistency and complex querying, while NoSQL offers scalability and flexibility. Common misconceptions include inflexibility of SQL databases and the lack of transactional support in NoSQL.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://dev.to/shohams/when-to-use-sql-vs-nosql-3o45>

## Community discussion

Top comments from developers on daily.dev.

**@fahurleandro** · 1 upvotes

> I found really nice that you highlighted the misconceptions.
>
> Indeed, we always need to ask, what do I need, and what tool offers it, right? It does not matter if SQL or NoSQL, React or Anguler or Vue.... and so on and so forth...
>
> Nice article, keep up the good writting!

**@dalamain** · 0 upvotes

> What I find hilarious is NewSQL - from wiki:
>
> "NewSQL is a class of relational database management systems that seek to provide the scalability of NoSQL systems for online transaction processing (OLTP)"
>
> Oh right so acknowledgement from the hipster "no sql" crowd as to why we still need relational dbs like SQL Server, Postgres, MySQL - which are battle tested. You couldn't make this up! 😂

---

Tags: [#backend](https://daily.dev/tags/backend), [#sql](https://daily.dev/tags/sql), [#postgresql](https://daily.dev/tags/postgresql), [#mongodb](https://daily.dev/tags/mongodb), [#mysql](https://daily.dev/tags/mysql), [#nosql](https://daily.dev/tags/nosql)

[View this post on daily.dev](https://daily.dev/posts/when-to-use-sql-vs-nosql-mwipbejry)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"When to use SQL vs NoSQL","url":"https://daily.dev/posts/when-to-use-sql-vs-nosql-mwipbejry","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/when-to-use-sql-vs-nosql-mwipbejry"},"datePublished":"2024-04-17T10:27:14.140Z","dateModified":"2024-05-09T08:39:06.345Z","description":"Choosing between SQL and NoSQL databases can be daunting. SQL excels in data consistency and complex querying, while NoSQL offers scalability and flexibility....","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/ae019456c98970130d2a8e01e3c0adcc?_a=AQAEufR","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/ae019456c98970130d2a8e01e3c0adcc?_a=AQAEufR","isAccessibleForFree":true,"articleSection":"DEV","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"DEV","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/devto","url":"https://daily.dev/sources/devto"},"commentCount":2,"discussionUrl":"https://daily.dev/posts/when-to-use-sql-vs-nosql-mwipbejry","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":166},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":2}],"keywords":"backend,sql,postgresql,mongodb,mysql,nosql","timeRequired":"PT4M"}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"DEV","item":"https://daily.dev/sources/devto"},{"@type":"ListItem","position":3,"name":"When to use SQL vs NoSQL"}]}
{"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/when-to-use-sql-vs-nosql-mwipbejry","comment":[{"@type":"Comment","text":"I found really nice that you highlighted the misconceptions.\nIndeed, we always need to ask, what do I need, and what tool offers it, right? It does not matter if SQL or NoSQL, React or Anguler or Vue… and so on and so forth…\nNice article, keep up the good writting!","datePublished":"2024-04-24T20:22:49.891Z","url":"https://daily.dev/posts/mWIPbejRY#c-aurG11XfZ","author":{"@type":"Person","name":"Leandro Miranda Fahur Machado","url":"https://daily.dev/fahurleandro","image":"https://media.daily.dev/image/upload/s--8uZaVInh--/f_auto/v1746515516/avatars/avatar_aeMf6dqKq1kWaBy3kD7s4"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}},{"@type":"Comment","text":"What I find hilarious is NewSQL - from wiki:\n“NewSQL is a class of relational database management systems that seek to provide the scalability of NoSQL systems for online transaction processing (OLTP)”\nOh right so acknowledgement from the hipster “no sql” crowd as to why we still need relational dbs like SQL Server, Postgres, MySQL - which are battle tested. You couldn’t make this up! 😂","datePublished":"2024-04-18T18:53:29.540Z","url":"https://daily.dev/posts/mWIPbejRY#c-CYX2nExOd","author":{"@type":"Person","name":"Dalamain","url":"https://daily.dev/dalamain","image":"https://media.daily.dev/image/upload/s--YZ5awdso--/f_auto/v1712931981/avatars/avatar_EQJW6BZf5fApDrjwDCxMh"}}]}
```