When should you store serialized objects in the database? (2010)
Bad ideas from 5, 10, er 20, er 30 years ago are stil bad ideas.<p>I know the HN police will cite me for no citation, so I&#x27;d say it comes with experience. The law changed at one point, and we were legally bound to be able to locate a customers record by a piece of data in a blob. The only way to fix the problem was to dump the massive (1tb+) table and reinsert them into a real schema. The engineering effort to do this took 9 months to get it right, because other people changed the way blobs were written out over the course of years.<p>Being clever doesnt pay, again.