I have used both techniques whilst working with oracle database.
And it all comes down to the scenario. But generally I want to keep my data
in as few places as possible, for security reasons, and for availability
reasons. And it is nothing complicated about storing a binary file in a BLOB
field in the database. You can still read it while working with datasets.. it
is serialized and encoded using Base64. And I do't like to store paths in
database, becuase then you create a depencence between the file system and
the application. And this is not good from an architectural point of view.
Of course when you need a third party application to access the file, then
perhaps the best choice would be to store the file in a shared folder. If it
can't be solved in any other way.. I always consider file systems as a last
resort...
but thats just me ;) Im no MVP or MCAD...
kind regards
Henrik
"R Reyes" wrote:
what are the pros/cons of uploading a file into a database (like access, sql
server, oracle) vs. uploading a file into a folder (and only storing its path
in a database table) ?
i've never had to upload a file into a database and am assuming it's easier
to just put files in a folder with its path stored in the database. storing
a file in the database seems like a bit more work and is just "another
solution" rather than a recommended one.
ideas and comments please? thanks.