Subject Re: [firebird-support] Store large amount of Binary Data in FB
Author Teträm Corp
yogiyang007 a écrit :
> Hello everyone,
>
> I am trying to create a software in which all the documentations that
> are generated in our organization should be stored.
>
> For this I have created a BLOB type field also.
>
> Now my problem is that the data that I want to store in this BLOB
> field consists of a variety of files which are .DOC, .TIF, .JPG, .RTF,
> .TGA, .PDF, .XLS, .PNG, .DWG, .DXF. The average file size is around 23
> MB and there are currently 300 files.
>
> How can I store these files in the BLOB field?
>
> Is it advisable to store such huge binary data in FireBird?
not really

a more academic way is to store a path to the file in the database, and
store the file itself in specific place (a dedicated disk for example)
the access to the file could be: windows file sharing, or FTP, or HTTP,
or something else