just a thought, not all 5GB is consumed in a second when a viewer watches. streaming is going to be in packets that might be much smaller than 5GB. so the server side estimation for bandth of 10TB/second seems to be over estimating. also you talk about storing uploaded file in different formats, that would mean your initial analysis of 5PB will increase to 10 or 15 PB depending on how many formats you store the video in.
No one has explained the capacity estimation in so easy terms. I was super worried prior to seeing this video but feel so relaxed now. Thanks, Pratiksha!
Hi Pratiksha, This was an unbelievably good Video. Would you share with us, what excalidraw libraries have you used in this diagram. I did not get all those icons in the "system design" libraries alone.
One of the finest explanation I have ever seen , I am following a more than dozen of System design channels but the way putting the flow is at the top, Please make more such videos for other topics like chatApps, Google Docs ..etc
great video -- I would add -- Video files specifically are usually served using MPEG DASH or HLS -- where the same content is saved at multiple resolutions so it can be served to multiple clients depending on b/w.
Nice video. I would suggest you say codecs and file size types for the kind of user connection and device vs mp3 and mp4 formats only. Also a CDN would be necessary to start the instant streaming from a CDN closest to user. This CDN can have a push to cache
You are amazing !! Streamlining all topics , explaining everything in such a short time. No one does like that .. appreciate your hard work. Thanks for the videos..
Wow, your System Design videos are the best I've found on TH-cam. I love how to the point, concise, yet through the videos are. I also like how you use a realistic visual tool as well. Thank you for putting the time to make these!
Hi Pratiksha, thank you so much for the awesome content! I started using excalidraw. But I could not find a library/option with a database table (such as you used to draw the video metadata table). Can you please share the name of the library that has it?
Hello Pratiksha, really appreciate for the level of content you are sharing for everyone…just ❤ it, wondering, do you have a plan to continue this series with new contents on online food booking, delivery system, online betting system, cab booking system etc ?
Hey Pratiksha. Great videos and explanation. One query- you say that you will use a SQL database for Video Metadata and a nosql for some other info... Is it fine to use multiple DB types in a single system. I know you can, but wont it make the whole thing very complex?
Awesome Explanation ! Thanks a lot for the efforts you put into these videos. I have seen multiple system design related channels, but you follow a very systematic approach to solving the problems with great detail to each small thing. Maybe you can give a shot at Low Level Design videos along with these high level design videos too.
Thank you so much for sharing that! Comments from you all keeps motivated to make more videos. In the future, i would be happy to take a shot at LLDs as well!
Fir video URL table, if we have 10M video, each video is lets say 2HR and 4GB in size, if we split it into one minute chunks, each is of 34MB, i split video in 5min chunks each of 170MB, so 24 chunks per video. 10M * 24 = 240M, I think thats a huge data to store in SQL, we would need to worry about sharding here. ALso the files are already grouped, Using NoSQL DB here would be better, for each video we can store chunk info in single object
Bobby Z I use the signature version but I tNice tutorialnk most of the stuff was also available in the producer edition (I bought that first). I am using
Would it be better to only call upload service for a pre-signed url, and then have the user upload directly to cloud storage with the pre-signed url? If we upload to upload service, it looks like upload service is re-uploading it to Original Video object storage.
hi madam, I have got a doubt on Bandwidth estimation 6:58 , we are not delivering 5GB in one click, it's depends on video resolution, isn't it? Lot more to cover, features like comment, like, share, subscription, save, playlist, community, live streaming and so on.. never ending
Upload API param should also contains USER ID, ,description and other relevant details as this is the first point where the video comes in picture so we should have that parameters also in api??
That's great call out! Thank you for doing that. You could certainly add that to your design. When you are doing the interview, you will only have 45 minutes to an hour, so you can focus only on so many things. You don't want to get too detailed upfront and not be able to complete your design in given timeframe as interviewers may be judging your time management skills as well.
Hello Deep Kiran, Video Id can be numeric/alpha-numeric or UUID. There are multiple ways we can auto-generate a unique id for each video. Part ID will maintain the sequence of the video. Part ID 1 - will be the first part of the video, Part Id 2 will be the second part of the video, and so on! I hope this answers your questions!
I really liked the estimation simplification you did there. But I do not agree that category would be a string., categories are probably limited, so they would be a foreign key to another table. It would also be a very big red flag if you talk about mp3 for video and not mp4. Mpeg layer 3 is only for audio.
That's too much time on capacity estimation which might be an overkill just to let them know that "Oh!! its a lot!" Shows just math skills and doesn't say much about the candidate. What do you think? Instead spend time on deep diving a NFR.
Just focus on system design, that’s enough for us. We are not at all interested in interview setup, just don’t waste your energy on shooting in two dresses and then mixing.
Didn't get your Bandwidth calculation, 2000 QPS * 5GB,. I don't think 5gb is required, the video will be downliaded in chunks of may be 100MB each, as and when user plays the video. CMIIAW.
![BOWKYLION - วิงวอน (ex-change) [Official MV]](http://i.ytimg.com/vi/cLdnZWDaO-w/mqdefault.jpg)
probably the most effective system design video I found on TH-cam.
Thank you, Ali! I appreciate the feedback! Feel free to share it with your friends who may find it useful!
interviewer was so damn real 🤣, btw this is the best video i have seen , please keep continuing your work
just a thought, not all 5GB is consumed in a second when a viewer watches. streaming is going to be in packets that might be much smaller than 5GB. so the server side estimation for bandth of 10TB/second seems to be over estimating. also you talk about storing uploaded file in different formats, that would mean your initial analysis of 5PB will increase to 10 or 15 PB depending on how many formats you store the video in.
Most effective way of learning system design for beginner,Very easy and step by step method...Thanks Pratiksha!!
No one has explained the capacity estimation in so easy terms. I was super worried prior to seeing this video but feel so relaxed now. Thanks, Pratiksha!
You have given lots of clarity how the system design interview takes place. Thanks
I would really clap for you. This kind of explanation is very rare on youtube.
Adding api gateway for rate limiting etc... can also be done along with this.. Thanks for this tutorial
Hi Pratiksha, This was an unbelievably good Video. Would you share with us, what excalidraw libraries have you used in this diagram. I did not get all those icons in the "system design" libraries alone.
One of the finest explanation I have ever seen , I am following a more than dozen of System design channels but the way putting the flow is at the top, Please make more such videos for other topics like chatApps, Google Docs ..etc
Glad it was helpful!
15:24 we should probably do the checks first ( inspection etc ) before splitting to reduce time if any unwanted files / virus are uploaded
Perfect guide for system design interview. Great work maam.
great video -- I would add -- Video files specifically are usually served using MPEG DASH or HLS -- where the same content is saved at multiple resolutions so it can be served to multiple clients depending on b/w.
Nice video. I would suggest you say codecs and file size types for the kind of user connection and device vs mp3 and mp4 formats only. Also a CDN would be necessary to start the instant streaming from a CDN closest to user. This CDN can have a push to cache
Mam just perfect design ever saw I'm a fresher idk about this before this is the first video on system design for me i think i did the best choice
This is the first time I leave a comment, thanks so much for making these videos, they are one of the best system design videos I found on TH-cam!
Thank you very much!
really nice way to put things up in an system design interview
Great explanation!! Learn a lot, Can you make a seperate video on which DB (SQL vs NoSql) to use in different scenarios .
Great suggestion! Added to my list! Thanks
You are amazing !! Streamlining all topics , explaining everything in such a short time. No one does like that .. appreciate your hard work. Thanks for the videos..
Wow, your System Design videos are the best I've found on TH-cam. I love how to the point, concise, yet through the videos are. I also like how you use a realistic visual tool as well. Thank you for putting the time to make these!
Glad you like them!
Glad you like them!
Neat explanation. This gives us a template on how to approach system design questions. Thanks Pratiksha.
Glad you liked it
Hi Pratiksha, thank you so much for the awesome content! I started using excalidraw. But I could not find a library/option with a database table (such as you used to draw the video metadata table). Can you please share the name of the library that has it?
even i wanted the same
Nice video. I would suggest you say codecs and file size types for the kind of user connection and device vs mp3 and mp4 formats only.
Very nice . 👌
Hello Pratiksha, really appreciate for the level of content you are sharing for everyone…just ❤ it, wondering, do you have a plan to continue this series with new contents on online food booking, delivery system, online betting system, cab booking system etc ?
Really nice videos on sys design, would love to see more
More to come! Thank you for the feedback
Hey Pratiksha. Great videos and explanation. One query- you say that you will use a SQL database for Video Metadata and a nosql for some other info... Is it fine to use multiple DB types in a single system. I know you can, but wont it make the whole thing very complex?
I've been watcNice tutorialng tNice tutorials and you inspired to try to make soft so I thank you
Awesome Explanation ! Thanks a lot for the efforts you put into these videos. I have seen multiple system design related channels, but you follow a very systematic approach to solving the problems with great detail to each small thing.
Maybe you can give a shot at Low Level Design videos along with these high level design videos too.
Thank you so much for sharing that! Comments from you all keeps motivated to make more videos.
In the future, i would be happy to take a shot at LLDs as well!
Amazing quality and knowledge, thank you so much for making these videos!
Glad you enjoy it!
Pratiksha, which UML tool you have used?
I liked the way you explained the designing so easily with UML diagram.
Thank you for your feedback. I am using Excalidraw! It's a great collaboration tool. Check it out
It's so informative video
Thank you Digital Crucial :) I appreciate the feedback!
Do you think, in the data model design section, one should also mention relationships and cardinalities between entities?
Thank you so much!!! It did work and took less than 5 minutes!
Fir video URL table, if we have 10M video, each video is lets say 2HR and 4GB in size, if we split it into one minute chunks, each is of 34MB, i split video in 5min chunks each of 170MB, so 24 chunks per video. 10M * 24 = 240M, I think thats a huge data to store in SQL, we would need to worry about sharding here. ALso the files are already grouped, Using NoSQL DB here would be better, for each video we can store chunk info in single object
brilliant explanation in all the three videos thanks alot
Thanks for the feedback! Glad it was helpful!
thanks bro regards from Syria
Great Video. Each topic is explained well, Looking forward to more videos
Thank you so much! More videos to come!
concepts finally line up in my brain and...well, who knows? Maybe I'll be able to make sotNice tutorialng now.
Exceptional Video Pratiksha 👍🏻 Hope to see more such content
Thank you Ankur! I will try my best to bring good content.
You catch on really fast, it seems complex but once you learn the basics it pretty much branches into experintation
Thanks 👏 great explanation 👍
Thank you, Karthikeya !
hi! Thanks for the video! Which tool do you use for creating and working with the diagrams?
Seemed like Excalidraw to me
I am using Excalidraw.
Upasana is right! I am using Excalidraw.
How did you learn all this? work experience? o reading books? if so wich ones. Thanks
Bobby Z I use the signature version but I tNice tutorialnk most of the stuff was also available in the producer edition (I bought that first). I am using
Would it be better to only call upload service for a pre-signed url, and then have the user upload directly to cloud storage with the pre-signed url? If we upload to upload service, it looks like upload service is re-uploading it to Original Video object storage.
I´m in love with tNice tutorials tutorial!!!!
hi madam, I have got a doubt on Bandwidth estimation 6:58 , we are not delivering 5GB in one click, it's depends on video resolution, isn't it?
Lot more to cover, features like comment, like, share, subscription, save, playlist, community, live streaming and so on.. never ending
Upload API param should also contains USER ID, ,description and other relevant details as this is the first point where the video comes in picture so we should have that parameters also in api??
While doing storage estimations you have not taken into account the different file formats for each video..is that a miss?
That's great call out! Thank you for doing that. You could certainly add that to your design.
When you are doing the interview, you will only have 45 minutes to an hour, so you can focus only on so many things. You don't want to get too detailed upfront and not be able to complete your design in given timeframe as interviewers may be judging your time management skills as well.
anyone. I appreciate it!!
What is the `cache layer`? Do you implement it as a separate web service or attach it to the caller?
it could something like a redis database and it should work
one question! how will order of split videos be mantained? how will video id be decided?
Hello Deep Kiran,
Video Id can be numeric/alpha-numeric or UUID. There are multiple ways we can auto-generate a unique id for each video.
Part ID will maintain the sequence of the video. Part ID 1 - will be the first part of the video, Part Id 2 will be the second part of the video, and so on!
I hope this answers your questions!
Thanks a lot !!
I like it, thanks for your efforts!
Thank you🙏
TNice tutorials video really helped! Thank you ❤
Sis you're going too hard with the subscribe alerts. But excellent video nonetheless!
great video. thanks!
I really liked the estimation simplification you did there. But I do not agree that category would be a string., categories are probably limited, so they would be a foreign key to another table. It would also be a very big red flag if you talk about mp3 for video and not mp4. Mpeg layer 3 is only for audio.
Thanks for sharing that!
That's too much time on capacity estimation which might be an overkill just to let them know that "Oh!! its a lot!" Shows just math skills and doesn't say much about the candidate. What do you think? Instead spend time on deep diving a NFR.
Good one thanks 🙏
Yeah too, exceptt I feel the exact sa way i did.
He had when he "pitched down the Nice tutorialgh hats at the end of the phrase. "
Why interviewee looks more mature than interviewer 😂
Ha ha ! 😝
I also really appreciate if the author make a video about UnsetupIt, an app that can isolate or remove softs from a . TNice tutorials app is really
soft interface support.
Just focus on system design, that’s enough for us. We are not at all interested in interview setup, just don’t waste your energy on shooting in two dresses and then mixing.
Hola I can hear ya better now 😮❤❤❤❤
Thanks for sharing that!
👍
learn what they are doing. I would learn how to lay down drums on the channel rack and use so loops, and then once you have your
Didn't get your Bandwidth calculation, 2000 QPS * 5GB,. I don't think 5gb is required, the video will be downliaded in chunks of may be 100MB each, as and when user plays the video. CMIIAW.
has anyone ever co up with such a good lody, and forget it seconds later
away with what setups can generate.
No one explains SD better than you❗
Thought I was the only one "General S hettings...for the S het"
Ur a telugu girl i know please do vedios also in telugu
hi,
I am sorry to disappoint but I do not know Telugu. :)
Well my GMS is softing like my old broken Hard Drive ?!
How this pretty woman came in suggested videos. 😂
Ha Ha!
but I guess I just have to deal with bluetooth, tNice tutorials is a big con.
My brain is overheating
p͎r͎o͎m͎o͎s͎m͎ 😠
Very very helpful video.. Good explanation...
I would also like to know how will you handle authentication and authorization? @pratikshabakrola