Re: storing pickles in sql data base

2007-07-12 Thread Gabriel Genellina
En Thu, 12 Jul 2007 14:18:11 -0300, Chris Mellon <[EMAIL PROTECTED]> escribió: > On 12 Jul 2007 06:00:59 GMT, Marc 'BlackJack' Rintsch <[EMAIL PROTECTED]> > wrote: >> On Wed, 11 Jul 2007 17:14:43 -0500, Chris Mellon wrote: >> >> > [pickle] >> > >> > Protocol 0 (the default) is a text protocol,

Re: storing pickles in sql data base

2007-07-12 Thread Chris Mellon
On 12 Jul 2007 06:00:59 GMT, Marc 'BlackJack' Rintsch <[EMAIL PROTECTED]> wrote: > On Wed, 11 Jul 2007 17:14:43 -0500, Chris Mellon wrote: > > > [pickle] > > > > Protocol 0 (the default) is a text protocol, it's safe to store in a > > text field or write to a text file. > > It's not really a text p

Re: storing pickles in sql data base

2007-07-11 Thread Marc 'BlackJack' Rintsch
On Wed, 11 Jul 2007 17:14:43 -0500, Chris Mellon wrote: > [pickle] > > Protocol 0 (the default) is a text protocol, it's safe to store in a > text field or write to a text file. It's not really a text protocol it's more a binary protocol that uses just the ASCII range of byte values. You have to

Re: storing pickles in sql data base

2007-07-11 Thread Chris Mellon
On 7/11/07, Nick Craig-Wood <[EMAIL PROTECTED]> wrote: > David Bear <[EMAIL PROTECTED]> wrote: > > I need to store pickled objects in postgresql. I reading through the pickle > > docs it says to always open a file in binary mode because you can't be sure > > if the pickled data is binary or text

Re: storing pickles in sql data base

2007-07-11 Thread Nick Craig-Wood
David Bear <[EMAIL PROTECTED]> wrote: > I need to store pickled objects in postgresql. I reading through the pickle > docs it says to always open a file in binary mode because you can't be sure > if the pickled data is binary or text. So I have 2 question. Can I set the > pickle to be text -- a

Re: storing pickles in sql data base

2007-07-10 Thread Philippe Bouige
In article <[EMAIL PROTECTED]>, David Bear wrote: >I need to store pickled objects in postgresql. You have this : http://blog.melhase.net/articles/2006/06/06/ a-tale-of-postgresql-types-and-python http://blog.melhase.net/articles/2006/06/13/ auto-postgresql-pickles Philippe Bouige

Re: storing pickles in sql data base

2007-07-10 Thread Gabriel Genellina
En Tue, 10 Jul 2007 20:32:01 -0300, David Bear <[EMAIL PROTECTED]> escribió: > I need to store pickled objects in postgresql. I reading through the > pickle > docs it says to always open a file in binary mode because you can't be > sure > if the pickled data is binary or text. So I have 2 qu

storing pickles in sql data base

2007-07-10 Thread David Bear
I need to store pickled objects in postgresql. I reading through the pickle docs it says to always open a file in binary mode because you can't be sure if the pickled data is binary or text. So I have 2 question. Can I set the pickle to be text -- and then store it in a 'text' type field in my sql