Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Uploading images to a databaseUploading images to a database
Previous
 
Next
New Post
3/26/2009 12:52 PM
 

Is there a way to upload images to a SQL database instead of the file folder?

For security reasons, external users are not allowed to upload files and images to our servers. I would have to upload them for them then tell them that they were there, not a very viable solution. The only other option I can think of is to have the images load to an image field in the SQL server 2005 database table.

There will be a limited number of bloggers, about 15, and they won' t be uploading pictures for every blog entry, so it should be manageable.

How difficult would it be to modify the upload file/image part of the blog module to do this?

 

 

 
New Post
3/26/2009 4:35 PM
 

upload via DNN does not require user permissions in file system, only defined in DotNetNuke itself. IMHO uploading into the database is not a very good solution, because it is slow, does not solve security risks and puts load on the server.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
3/26/2009 8:11 PM
 

I want to put another point of view here.

I think putting images in the database is the right thing to do.  You are going to the database anyway, so I think there is probably less IO overall.  I completely disagree that it is slow, but I would love to see evidence.

The CRUCIAL advantages are that adding/updating the image can now be transactional along with the other activity, and when it comes to backup everything is in the same place.  You can be CERTAIN that the images in the database backup go with the other data in the database backup.  When you have a database back up, plus a few random file backups you have no idea what belongs with what.


Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
New Post
3/27/2009 4:59 AM
 

Hi,

despite performance issues, generally SQL space is offered at a higher price of the normal disk space by hosting providers. The module also features a simple but robust uploading feature that organizes images in subfolders, thus making portability quite simple.

Best regards,
Dario Rossa

 
New Post
3/27/2009 10:07 AM
 

Our SQL servers databases are backed up every night.

I put images in a database for another website where they need to post pictures everyday during the summer and I haven't have any problems with response time. The site is older and probably needs updating, but it works fine. No one has complained about the download time of the images.

I do like the idea that everything is in one place. If we are having problems with one of the servers, I always have the option of moving a backup copy of the site to another one. If all of the data is in the database, I wouldn't have to worry about losing any information that has been submitted since the backup was created.

 

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Uploading images to a databaseUploading images to a database


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out