Should video clips and photos be stored in a table? 1

[RobertIngles]

Hi guys;

First my expertise is data and report analysis using Access and Excel so building a web app is totally new to me. I am building a data driven web app in Access. I have been using Access desktop apps for a decade but this has never come up. The access web app will allow users to view a large number of instructional videos (no more than 5mb but there will possibly be 100's) as well as storage for their profiles which will have photos (which could be in the 1000's) and possibly their own videos. My question is what is the best solution for storage of videos - do I store them in a table imbedded, do I store a hyperlink to a folder where the videos reside, or is there a storage method I haven't considered. Any advice you can offer is greatly appreciated - I would also really appreciate any suggested links or UDEMY courses that I could access. I'm thinking the closest type of site would be a dating site (it's not)

Many many thanks!!
Rob

 

[jrbarnett]

I would store the videos in a folder on the web server (or a mount from a file server from the web server), and have a text file folder with the URL relative to a base path in your system configuration.

Example - you have a configuration table/constant which has a value of

http://example.com/videos/

You have a table with a list of videos. One field gives the filename, you concatenate the two together to build your URLs, which then go into your HTML application or Acces front end.

Codecademy.com has some free tutorials which may or may not be useful in your case, it depends on your level of expertise in terms of HTML5 multimedia content and embedding that in your applications. There may also be others that would help, I suggest google or another search engine.

John