Store and Read video and audio and images

Question

Store and Read video and audio and images

Arshad Nazeer 21

Hi.
I want to store video and audio in SQL database and Source Tree.
I want to play video and audio after fetching it from Database and Source Tree in a browser.
I want to store images in SQL Database and Source Tree.
I want to display images after fetching it from SQL Database and Source Tree in a browser.

How to do it?

Is it a good practice to store video, audio, and images in database?

Thanks in advance.

AgaveJoe 31,361 Reputation points

2022-11-12T12:32:56.517+00:00

Is it a good practice to store video, audio, and images in database?

Using the files system is easier.

I recommend creating a proof of concept to determine if storing images and videos in a database works in your unknown use case.

Keep in mind, videos and images tend to be large files. Queries must be efficient. Use a primary to fetch image(s). Do not include the file content in the result set when rendering the tree. Also, you'll need to design a action or actions to stream the files to the client.

1 answer

Your answer

AgaveJoe 31,361 Reputation points

2022-11-12T12:32:56.517+00:00

Is it a good practice to store video, audio, and images in database?

Using the files system is easier.

I recommend creating a proof of concept to determine if storing images and videos in a database works in your unknown use case.

Keep in mind, videos and images tend to be large files. Queries must be efficient. Use a primary to fetch image(s). Do not include the file content in the result set when rendering the tree. Also, you'll need to design a action or actions to stream the files to the client.

Answer 1

Hi, @Arshad Nazeer

Based on the information you provided. I don't think it's a good way to store large files into SQL database.

Storing large files such as video and audio in the database will take up a lot of space and cause the database to expand. Also makes reading and querying files in the database slower.
It will make your database backups slower and take up more bandwidth. Fetching data from the database will take more time.

As already mentioned by community member( @AgaveJoe ), I also recommend that you use file system to store these source files. Store the file name and storage path in SQL database. File system is already optimized for storing, retrieving, and indexing files. You just need to look up the filename and storage path into the database. Obtain the file path by querying the database through the browser.

Best regards,
TengFei Xie

If the answer is the right solution, please click "Accept Answer" and kindly upvote. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Store and Read video and audio and images

1 answer

Your answer