Best strategy on storing files on server

  • Thread starter Thread starter NWx
  • Start date Start date
N

NWx

Hi,

I have an application who require to let users to upload files on server,
and "link" them to some other database records (projects, which allow user
to attach files to them)

How is the best strategy to store them on web server?

Should I store them in SQL server database, or as files on filesystem?

If I want to use database to store them, how can I upload and save the file
into a BLOB field?
Then, how to send it back to client if user want to download / open the
file?

Thank you for any suggestion.

Best regards
 
I would store the path to the file in SQL. From the client end, you could
transfer the files with FTP, System.IO.FileStream, HTMLInputFile, etc.

hth
Eric
 
Back
Top