Merlin Moncure wrote on 05.04.2007 23:24:
I think most reasons why not to store binaries in the database boil down to performance.
Having implemented an application where the files were stored in the filesystem instead of the database I have to say, with my experience I would store the files in the DB the next time. Once the number of files in a directory exceeds a certain limit, this directory is very hard to handle.
Things like "dir", or "ls" or listing the contents through a FTP connection become extremely slow (using HP/UX as well as Windows).
And you have to backup only _one_ source (the database), not two. Moving the data around from system a to system b (e.g. staging (windows) -> production (HP/UX)) is a lot easier when you can simply backup and restore the database (in our case it was an Oracle database, but this would be the same for PG)
Thomas
