Cloud girl: The battle of relational and non-relational databases | SQL vs NoSQL Explained | My notes in one page

Sept. 9, 2021

Here is the link. 

Which database is right for your application? SQL or NoSQL? Are you confused between relational and non relational databases? Want to know how they SQL and NoSQL databases are different? In this video I explain the difference and help you decide which database to use in which type of application. I am Priyanka Vergadia, Developer Advocate for Google Cloud, for more content 📌 Follow me on Twitter - https://twitter.com/pvergadia 📌 Follow me on Instagram - https://www.instagram.com/pvergadia/ 📌 Follow me on LinkedIn - https://www.linkedin.com/in/pvergadia 📌 GCPSketchnote Playlist - https://bit.ly/3jA8Ylz 📌 Visit my website to download the sketchnote image - https://thecloudgirl.dev/ #databases #nosql #sql #relationaldatabases #nonrelationaldatabases #db #dbms #rdbms

Type of databases

• SQL - relational
• Non-relational

SQL - Relational

Using a database with three tables: User, Product, Promo, structed to explain ACID. 

OLTP

Atomic - A 

Consistent - C

Isolated - I

Durable 

Google cloud, for example, cloud SQL, Cloud spanner 

grow vertically  

NoSQL - Non-Relational

Unstructured 

Large column  - BigTable

document - 

key value - BT

Graph - Janus + BigTable 

In memory - MemoryStore

Large data sizes

BASE - explain BASE in detail

Basically Available

Soft state

Eventually Consistency 

Horizontal scaling 

Actionable Item

Review the blog by looking up blogs using BASE protocol, and here is the blog to document detail how to understand BASE, using persistent message queue to support high availability and reduce coupling.