Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Accessing Files on a remote server

 
T Dreezy
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • 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?
 
Scott Selikoff
author
Saloon Keeper
Posts: 4008
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
Thanks,

Do you have any recommendations for a software that helps do this?
 
Scott Selikoff
author
Saloon Keeper
Posts: 4008
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • 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
  • 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
Saloon Keeper
Posts: 4008
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
OK Thanks!
 
chris webster
Bartender
Posts: 2407
32
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic