This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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.
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 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?