Jay Sprenkle wrote: > Just out of curiosity why is this data in the database? > I've seen very few applications where the blob is indexed or operated upon > by the database and it's always a pain to deal with it. We always just > left binary data in the file system and stored references to it in the > database. >
For us, we use the encryption module, and our blobs must be encrypted. I did not want to mess with encrypting the blobs myself and the associated key management. I also don't want to have to deal with the blob and data pointing to it to be out of sync. The atomicity of storing the blob and its meta data is very nice.
