Subject | Storing files |
---|---|
Author | Juan Pedro López Sáez |
Post date | 2004-09-23T09:25:43Z |
Hello everybody.
I want to store binary files related to some data in my firebird
database.
I don't want them to increase my database size because they are not so
relevant as the rest of my data, so storing them as blobs is not a good
solution for me.
I also don't want to mix my database housekeeping with them, so I guess
I should store them outside my database.
I'm thinking about using external tables to do the job. I know there are
some limitations because blobs are not allowed but I could work arround
this problem storing the files as chars.
The question is: do you think it's a good idea? Any advice would be very
apreciated.
Thank you very much.
Juan Pedro López
I want to store binary files related to some data in my firebird
database.
I don't want them to increase my database size because they are not so
relevant as the rest of my data, so storing them as blobs is not a good
solution for me.
I also don't want to mix my database housekeeping with them, so I guess
I should store them outside my database.
I'm thinking about using external tables to do the job. I know there are
some limitations because blobs are not allowed but I could work arround
this problem storing the files as chars.
The question is: do you think it's a good idea? Any advice would be very
apreciated.
Thank you very much.
Juan Pedro López