From: "J. B. Rainsberger" <jbrains762@...>
Date: 2006-10-20T08:51:47+09:00
Subject: Storing a Hash in a database table using YAML--anything better?

I'm a beginning Rails programmer, so please be gentle.

I want to store a hash as a single row in a database table. I'm 
currently storing each name/value pair as a row with a reference back to 
the "parent" row, but that seems unnecessarily complex. I want to know 
whether you have any better suggestions than what I plan to try to do.

I plan to write the hash into the row in a single column by YAMLing it. 
I would, of course, unYAML on read operations.

I do not plan ever to need to run a query on a single key in this hash, 
so I feel comfortable storing it blob-like this way. I just wanted to 
know whether anyone knows of a better way than YAML formatting/parsing 
in my Rails model object.

Thanks for your help!
-- 
J. B. (Joe) Rainsberger :: http://www.jbrains.ca
Your guide to software craftsmanship
JUnit Recipes: Practical Methods for Programmer Testing
2005 Gordon Pask Award for contribution Agile Software Practice