Subject Re: [firebird-support] Storing images.
Author Ann W. Harrison
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.