CODEWITHSUNDEEP
sqlblob
SiggyF
SiggyF

Reputation: 23145

What should I store in my blob field?

I try to use blobs as little as possible. When possible I replace blobs by a link to a file. I can only think of a few times that I needed a blob. I used to put zipped pickled python objects in there, but I use mongo or couchdb these days for that. One thing I still use it for is to store wkb (gis) objects. This made me wonder, what do other people put in their blob fields?

Upvotes: 1

Views: 821

Answers (3)

Mr Shoubs
Mr Shoubs

Reputation: 15399

They have disadvantages..., so tried to ignore them, especially now file-stream exists in SQL2008.

Upvotes: 1

PSK
PSK

Reputation: 17943

BLOB accepts any data, all the items stored in the BLOB are stored in whole disk pages in separate disk areas from normal row data. Normally in a BLOB you can store any data generated by your program, images, graphics, video, audio or different types of documents.

Upvotes: 1

OMG Ponies
OMG Ponies

Reputation: 332571

Whatever binary data needs to be stored - typically images & documents (Word, PDF).

Upvotes: 2

Related Questions