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

2006-07-03 Thread Kent Johnson
Emily Fortuna wrote: > > 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? > Ideally, I'd like to be able to search the data in these dicts. Is > there a w

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

2006-07-03 Thread Emily Fortuna
> 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? Ideally, I'd like to be able to search the data in these dicts. Is there a way to do this? If not, PickleCo

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

2006-07-03 Thread 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 ob

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

2006-07-03 Thread Kent Johnson
Emily Fortuna wrote: > Hello all, > 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

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

2006-07-03 Thread Emily Fortuna
Hello all, 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 diffe