Database design and logic for storing media files on a file server

• Jason Wilks

  Old Hand

  Points: 389

  More actions

  September 23, 2022 at 6:14 pm

  #4091305

  In my application (it's similar to a social media app) , there are several areas where a user can upload a media file. Mostly pic and video files.  For example, a user has there own "homegroup" where they can post topics and attach media files to the post.  So I have a post and post attachment table.  In the post attachment table I am planning to have a field, uploaded_media_ref, that contain a unique id or filepath to the location of the file where it was uploaded to the server.   Does the application need to generate a unique file "ID" which must be the name of the file which matches the field contents of uploaded_media_ref?

  What is the best way to accomplish this type of functionality?  I've looked and I can't seem to find many examples out there , but I would think this is a common thing.  Just trying to not invent the wheel...

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  September 24, 2022 at 7:10 pm

  #4091601

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• September 29, 2022 at 10:13 am

  This was removed by the editor as SPAM

• September 29, 2022 at 10:15 am

  This was removed by the editor as SPAM