Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I've done similar for most SQL databases having either an xml, or json column to store ancillary information that didn't need to be accessed or indexed in ways that aren't programmatic.

For example, if you support Amazon Payments, Paypal and a payment gateway, the shape of the data for the transaction is different, and rarely looked at, why not shove it into a bigtext/blob field as xml/json.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: