[Openinteract-dev] Re: [Openinteract-help] Multifield values for database storage?

[Chris W. <ch...@cw...>]

* Terrence Brannon (bl...@sv...) [011105 00:47]:
> i havent dealt with it in awhile. Jswartz, who is using Class::DBI, 
> might be able to chime in with some input.
> 
> my first thought on the subject is that Storable uses a binary format 
> for storage , so a BLOB field in a database might work... just a thought.

Sure, that's one way. And in fact this would be pretty simple to
implement now using the method I mentioned in the previous email.

> the other obvious thing is to store several rows per object, one row
> per array element.

Sure. It might be interesting to code this using the pre-save and
post-fetch methodology I mentioned earlier. You might be interested to
poke around a bit with ESPOPS, which is at:

  http://www.pserc.cornell.edu/ESPOPS/ESPOPS-0.4.tar.gz

This work will be folded into SPOPS in the hopefully near future.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.