Win a copy of Terraform in Action this week in the Cloud forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

Accessing Files on a remote server

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,

I'm thinking of developing an application in which users can upload/download files (of any type) from a database on a remote server. Any ideas as to which database program I should look at?
 
author
Posts: 4278
34
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
While databases can handle files, as binary items (blobs), its not generally a good practice. One of the problems with putting files in the database is that they often outweigh the structured data, making the database difficult to work with. In general, files aren't good places for databases because they are completely unstructured. The database can't normalize, index, or do much with binary data other than store it. There are some exceptions to the rule, but if the files are large enough, or you are allowing arbitrary sized files, its better to manage them in a file system.
 
T Dreezy
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks,

Do you have any recommendations for a software that helps do this?
 
Scott Selikoff
author
Posts: 4278
34
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Software? Do you mean using JDBC or accessing a database directly? Also, you may have missed my point that putting lots of files in a database is often a bad practice.
 
T Dreezy
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sorry I'm a total noob at this lol

I understood your earlier point that putting lots of files in a database is not recommended, and managing them in a file system is a better option.

My question is are there any tools out there that help in this file system management, or is this done manually through coding?
 
Scott Selikoff
author
Posts: 4278
34
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oh, I misread too. Often, managing files is done manually through coding although there are document management systems like Documentum, SalesForce, etc, but these usually for enterprise-level solutions. If you're developer a Google AppEngine project, it has its own method of managing files.
 
T Dreezy
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
OK Thanks!
 
Bartender
Posts: 2407
36
Scala Python Oracle Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

T Dreezy wrote:Hi all,
I'm thinking of developing an application in which users can upload/download files (of any type) from a database on a remote server. Any ideas as to which database program I should look at?



Depending on the type of files you are storing, would MongoDB help? Haven't used it myself, but I've seen various references to it being used by newspapers as a document management system.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic