NoSQL vs SQL: What's better?

You can follow me at:

#SystemDesign #InterviewReady #Coding

[cmelgarejo]

So use cases for NoSQL come in the form of things like social networks, video streaming and their comments stuff like that. For things that need transaction consistency like commerce you're better off with a SQL db

[anuz]

my rule of thumb is, Always go for SQL database in every situation and only go for noSQL if you really need it.

[darenzou]

SQL databases can be sharded, in face any data store can, for some sharding mechanisms. Also worth consideration is whether the workload will be more read or write heavy.

[sd-nmlw]

The best explanation, I have been over so many videos, but this one is crsip, to the very point😊

[cutedoggo]

Best 1 min video about the subject thanks bro!

[doronsages]

Thanks for the great video!
What about read heavy vs write heavy systems?
And also, MongoDB does support transactions (and ACID in general) since 4.2, right?

[RahulKumar-rgce]

Nice. Request you to please also cover NewSQL database like yugabyte etc.

[Vedsten]

But then how do you build scalable systems when transaction support and consistency are required? For example a credit card processing company or a banking use case? Traditionally, relational DBs scale vertically and poorly horizontally.

[niranjhankantharaj]

@gkcs There are no-sql DBs like cockroachDB, spannerDB which can offer strong consistency guarantees.

[Tanmaygaming]

Need to update this video cause AWS dynamoDb gives you support now for ACID

[SuperHuman]

You are talented but wher you works and how much earn per annum. How many years of experience and which tech stack you are good at ??

[allinonevideo]

Ok got it. What I don't understand is how they make e-commerce with MongoDB/Nosql then. Are there any mechanism they use for transaction or consistency? Or they use microservices and use different database systems for different parts?

[QLZR]

Bruh, i swear indians always better on explaining about IT rather than teacher on my university💀💀

[sangaranaarayananr]

But in recnet times there are many cloud based sql providers who support auto scaling and sharding so ig in near future the serverless sql will become more.powerful

[swapnasaritnayak]

This is misinformative, sql supports sharding and nosql supports transactions