I am in a current impase. Our application needs to store files, using a remote repository or storing files into a database. We haven´t no care before about this issue, and we are not sure what can be better for us.

The main issue about store files at DB is about performance. I think this is the only real problem can crash. Meanwhile, put files on DB you can manipulate better, bring it easily using queries, can use DB security and more.

If us will not choose db file storage, we can use a versioning control like CVS or SVN. But will impact in much more codification, more tests, etc.

Our app use two database systems, one is a SQL Server, the other is a local db (derby) maintained into a user local machine. SQL can handle and send datas to a local db, a local db can handle and send datas to a remote db.

This process to send and recieve datas, can be used to send and recieve also files stored into a db or a repository.

I think db file storage better. But I need sugestions and advices about to use or not to use this solution. Thanks all! And sorry for my poor english.