Handling Large Blobs easy
Where should you store the *metadata* (e.g., Uploader User ID, Creation Date, Tags) for a large video file?
- A Inside the video pixels.
- B Nowhere.
- C In a SQL/NoSQL Database, alongside a reference URL (pointer) to the Object Storage location.
- D In the filename only.
Answer: C. In a SQL/NoSQL Database, alongside a reference URL (pointer) to the Object Storage location.
Hybrid approach: Big data goes to Object Store (S3). Small structured data goes to DB (Postgres) for fast querying/filtering.
One system design question a day, with spaced repetition so the ones you miss come back.
Get the appRelated questions
- Why do modern sites serve images in WebP or AVIF format?
- What does the acronym BLOB stand for?
- Why do we sometimes convert binary images to Base64 strings?
- What is an 'Origin Shield' or 'Mid-Tier Cache' in a CDN architecture?
- For a feed with 100 images, why use 'Lazy Loading'?
- How does HLS/DASH handle a user moving from WiFi to 4G (Variable Bandwidth)?