Handling Large Blobs easy
Why is it generally bad practice to store large video files directly inside a SQL database (e.g., in a BLOB column)?
- A It bloats the database size, making backups slow and consuming expensive RAM/Connections for file serving.
- B SQL databases cannot store binary data.
- C Videos are not secure in SQL.
- D It is faster than the filesystem.
Answer: A. It bloats the database size, making backups slow and consuming expensive RAM/Connections for file serving.
Databases are optimized for structured queries on small rows. Trying to stream a 1GB movie through a DB connection blocks that connection from serving other users.
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)?