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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 0
Should heavy binary files not be stored in database? 1
Problem cleaning up temp folder after saving files to database 6
Any file management strategy? 5
How to upload a text file into SQL Server via ASP.NET? 1
Best Ways to Convert OST to PDF? 3
Ajax File Uploader 7
Adding items to a database 1

Back
Top