On Mar 9, 2005, at 12:39 PM, <operationsengineer1@yahoo.com> wrote:
> right now, i'm thinking that storing a link to the
> file's server location is probably better than storing
> the document in the db itself. i'm also thinking that
> i could request that the only the file name be entered
> into the db and then i could append the file name to
> the directory link as required?
>
> is this the best way? is there a hidden *gotcha*
> involved that i might need to be aware of?
Do some searching in the list archives -- you'll find plenty of
previous discussion on this.
Your approach will work, but the down side is that documents are not
under transaction control. Further, they don't benefit from other
database facilities such as searching and backup.
The right approach for this depends highly on the nature of the
application, runtime environment, and size of the documents.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL