Subject Re: [firebird-support] Storing images.
Author Claus Heeg
Hi
I store TIff files in databases by stream-blob-load written in C -
since 18 months;
It is fun with FB. Linux Server and MAC OSX Clients are synchronizing
over Internet connections both data (=blobs too).
Well the very reason to use BLOB for tiff files was a handy
functionality of exchanging BLOB instead of bouncing files across the web..
and there is a nice guy of IBPhoenix in UK giving me some hints about
streaming blobs in FB....
yours
Claus

Ann W. Harrison wrote:

>Adrian Wreyford wrote:
>
>
>
>>I can store Jpeg images using Jason's IB_JpegImage, but don't think this is
>>the way to go.
>>
>>Reason:
>>
>>No control over the size of the image file that the end user will be trying
>>to store in the blob file.
>>
>>I can resize the images, and also compress to a certain degree to limit this
>>factor, but still going to overload the database with large amounts of image
>>data.
>>
>>
>
>Probably not. Databases can get very big with no particular problems,
>especially if the data is in blobs. It does present a problem with
>backup, because the normal databases backup utility, gbak, doesn't
>support incremental backup. Version 2 introduces a new, physical backup
>mechanism that does incremental backups.
>
>
>
>>I have read somewhere that Firebird can store to files, and not the .FDB.
>>
>>
>
>Yes, but it's not what you want. People who choose not to store images
>in the database usually write out files through their application and
>store file names in the database. That won't work at all with IBO -
>well it might if you used some smoke, mirrors, and UDF's, but I don't
>recommend it.
>
>
>
>Regards,
>
>
>Ann
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>



[Non-text portions of this message have been removed]