is a BLOB more secure than allowing write permission to a directory on a web server -


i building system allows entry database (think user accounts if want) have image associated it. these small images , there won't many of them.

i know general pros/cons of using blob , doesn't seem problem in case. security on project important though. more secure set directory on windows server site can store images uploaded user instead of sticking image in db blob?

so potential security concerns on web users loading image server significant enough take small performance hit or being on cautious?

the site built in asp.net 4.0 , database sql server 2008, server using host site windows server 2003 or 2008.

yes using blobs in sql database store sensitive information safe.

1)completely eliminates problem of directory traversal.

2)easy apply access control on file file basis , link users/groups.

3)the database has built in encryption.

alternatively safe , faster approach store files outside of web root. change file name primary key , store metadata (such access control) in database. when serve file asp.net can primary key based on file name , open file on disk drive.


Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

html - Instapaper-like algorithm -

c# - How to execute a particular part of code asynchronously in a class -