SQL vs NoSQL - Who Wins? | Systems Design Interview 0 to 1 with Ex-Google SWE

Pretty much the only relationships in my life at this point are many to many ones

[firoufirou]

I like the video, just about the conclusion about the choice between relational vs non relational db, I think it shouldn't rely on whether there are relations between the data or not, but rather on the need to denormalize vs normalize the data. Sometimes we have data that have relations, but we want to denormalize it, because updates and deletes may be rare that we can afford for these operations to take some time, but we want fast reads.
I think the choice, of whether to normalize vs denormalize, will depend on the SLAs we want for each operation (read, update, delete, write) and how the queries will look like (we want to optimize reads, we want that updates), if the choice is to normalize, then the DB is better be relational to have the relations, foreign keys and the ability to join handled for us. But on the other hand, if we decide to denormalise, we can sometimes find relational DBs that perform better based on the usecase and on how other parts are implemented (Indexes, ...)

[bulioh]

i appreciated the your mom jokes probably way more than i should have

[LokendraSingh-]

I like to think of SQL as the starting point. When we want to scale, we'll have to compromise on certain functionalities of SQL. We can start by dropping foreign key constraints, partitioning tables, sharding based on certain keys and somewhere in between NoSQL will start to make sense to meet the SLAs

[psychechip]

I laughed hard at the decommissioned mom station. Really caught me off guard there

[jh]

Do a Chiraq vlog!! Lots of transactions each day, records constantly being created and destroyed and an ever-changing many to many relationship

[akul]

Hi Jordan, great video as always! This might be a silly question. In the Train station example using SQL, is it possible to store both tables in the same database? This way we can avoid 2PC and also network calls.

[karan-lhmj]

What books do you read for system design?
What are your sources?
Please tell