For what it is worth i have used custom fields for this type of thing with great success!
On Tuesday, July 24, 2012 8:20:03 AM UTC-7, Anthony wrote: > > You could use a SQLCustomType field: > http://web2py.com/books/default/chapter/29/6#Custom-Field-types-(experimental) > . > > Anthony > > On Tuesday, July 24, 2012 8:34:07 AM UTC-4, Omri Har-Shemesh wrote: >> >> >> Hi web2pyers, >> >> very often, I have a field in the table which has to hold a complicated >> value (most often numpy arrays). The way I implement it is that I use >> "text" as the type of field, and then simply pickle.dumps(my_value) when >> I save the field, and then pickle.loads(value_from_db) to access the field >> again. >> >> My suggestion is simple - create field that automatically pickles the >> values >> it gets and unpickles them on extraction. Is this already implemented? >> Do you have other suggestions on how to implement this so that I won't >> need >> to pickle every time I access the table? >> >> Best wishes, >> Omri >> > --