Why NoSQL?

Photo by Sharon McCutcheon on Unsplash

Relational vs non-relational

+----+------+--------+
| Id | Name | phone |
+----+------+--------+
| 1 | Nick | 800081 |
| 2 | Bob | 700071 |
+----+------+--------+
+----+-----------+------------+-------+
| Id | Client_Id | Name | Price |
+----+-----------+------------+-------+
| 1 | 1 | "HDD" | 100 |
| 2 | 1 | "SSD" | 200 |
| 3 | 2 | "Computer" | 500 |
+----+-----------+------------+-------+
[
{
id: 1
value: {
name: "Nick",
phone: "800081"
order: [{name: "HDD", price: 100}, {name: "SSD", price: 200}]
}
},
{
id: 1
value: {
name: "Nick",
phone: "800081"
order:[ {name: "Computer", price: 500}]
}
}
]

Changing a schema

alter table Client add column email varchar(500);

Scaling

Consistency

Conclusion

--

--

--

🚀 Marvelous Senior Backend Software Developer 📚 Like to share my knowledge 🎤 Beginner Public Speaker 🏠💻 Live and work in London https://github.com/oleg-sta

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

#BackupFAQ — If my support expired does it affect my software licence?

How to optimize your live stream timing

Git and Github — TechnoPals

Connecting Applications with Blockchain Ecosystems (Axelar Network)

Friendlychat-android

Creating e-mails with Maizzle

https://maizzle.com/

Introduction: Site Reliability Engineering

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Oleg Stadnichenko

Oleg Stadnichenko

🚀 Marvelous Senior Backend Software Developer 📚 Like to share my knowledge 🎤 Beginner Public Speaker 🏠💻 Live and work in London https://github.com/oleg-sta

More from Medium

Creating meaningful pull requests

An Introductory Guide to Microservices Architecture

An Introductory Guide to Microservices Architecture

The SOLID Principles

How can coders help with code reviews?