Re: [SQLObject] Pickling

[charles b. <li...@st...>]

Hi Philippe,

I'm pretty new to SQLObject, but I also just ran into this issue.  I was
using pickle(shelve) as a temporary way to add persistence to dict type
session data in quixote, and wanted to associate a SQLObject with the
session.

This is just a guess, but it makes sense on a conceptual level that pickle
should not allow storing data related to thread dependent objects (like
SQLObjects).  There is no guarantee that the process associated with an
object will still exist when the pickled data is unpickled (the whole point
of pickling anyway... persisting across processes).  For SQLObjects
specifically, there are database connections associated with the object.

I then realized that pickle and databases are both ways to add persistence
to data.  Therefore, whatever data you are trying to persist using pickle,
you may just want to persist using SQLObject.

Now if only I could figure out a way to easily map an existing dict type
object to a SQLObject I'd be set.  Anyone else have experience/advice on
doing that??

> PS: I'm not subscribed to the list, please reply to ph...@re...
Why not join?  Wouldn't want you to miss other responses... ;)

-Charles.