[Tutor] storing dict objects in in a database through SQLObject

[Dustin J.Mitchell]

You'll actually get better support from sqlite than from other 
databases.  The question is one of balance: are you more concerned with 
easily getting your dicts and tuples back intact, or with executing 
queries on the *contents* of those dicts and tuples?  Sqlite will treat 
pickles as opaque objects, and will be unable to do anything with their 
contents.

Dustin

On Jul 3, 2006, at 10:10 AM, Emily Fortuna wrote:

> I am experiementing in storing Python objects in a SQLite databse using
> SQLOjbect.  I want to store dicts and tuples in the databse, but as far
> as I can tell the only way to do this is to create a PickleCol.  Is
> there some other better way to store this data?  EnumCol?  Would a
> different database interface support this idea better?