The video provides a clear, step-by-step explanation of a common system design problem, using visual aids and addressing potential improvements, which is highly valuable for aspiring software engineers preparing for interviews.
This video explains how to design a file upload service, similar to Google Drive, for a software engineering interview. It covers using PostgreSQL for metadata and S3 for file storage, optimizing for both uploads and downloads by using presigned URLs to bypass server transfer.
File Upload Service System Design. Yes I designed a Google service on AWS. Could do the same thing with the Google equivalent. If you want to learn how to design production grade systems, check out The Daily Dev on the App Store. #systemdesign #coding #programming
For today's software engineering interview,
Introduce the problem: design a file upload service.
Initial solution: server and database for file storage.
Refinement 1: store metadata in PostgreSQL, files in S3.
Refinement 2: use presigned URLs for direct S3 uploads.
Download process: use presigned URLs for direct S3 downloads.
Google: (a) it APPEARS - a logo on screen, removing it would not change what happens in the video. PostgreSQL: (a) it ACTS - it is used as a database to store file metadata, removing it would change what happens in the video. S3: (a) it ACTS - it is used for object storage, removing it would change what happens in the video. The Daily Dev: (a) it ACTS - it is mentioned as a resource to learn system design, removing it would change what happens in the video. Stan Store: (b) it merely APPEARS - it is the creator's bio link, removing it would not change what happens in the video.
check out The Daily Dev on the App Store
Playing this video’s own audio, so you’ll hear the creator over the sound.
Software engineering interview tutorials for developers preparing for technical interviews
All time.
Promotes 2 products. Create free account to see more.
Outliers and viral hits: their videos on Overshot, all time.