What should I store in my blob field?

Question

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?

I heard mongo guisado is quite tasteful. [1] http://allrecipes.com//Recipe/mongo-guisado-mung-bean-soup/Detail.aspx — SiggyF, Jul 22 '10 at 22:25

score 2 · Answer 1 · answered Jul 22 '10 at 22:01

2

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

answered Jul 22 '10 at 22:01

OMG Ponies

325,700
82
523
502

Binary serialized objects are another option. – Peter T. LaComb Jr. Jul 22 '10 at 22:07

score 1 · Answer 2 · answered Jul 23 '10 at 05:25

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.

score 1 · Accepted Answer · edited May 23 '17 at 12:27

1

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

edited May 23 '17 at 12:27

Community

1
1

answered Jul 23 '10 at 09:21

Mr Shoubs

14,629
17
68
107

What should I store in my blob field?

3 Answers3