Re: [sqlalchemy] PostgreSQL hstore custom type?

2010-05-07 Thread David Gardner
Thank you, I haven't started using hstore in my production environment yet, but wanted to do some tests with it as a way for users to attach arbitrary key/value metadata to nodes. Are you currently using a Gin or Gist index on your hstore columns? Yes, actually I've got a pretty good start on

Re: [sqlalchemy] PostgreSQL hstore custom type?

2010-05-07 Thread Kyle Schaffrick
On Fri, 7 May 2010 09:01:05 -0700 David Gardner dgard...@creatureshop.com wrote: Thank you, I haven't started using hstore in my production environment yet, but wanted to do some tests with it as a way for users to attach arbitrary key/value metadata to nodes. Are you currently using a Gin or

Re: [sqlalchemy] PostgreSQL hstore custom type?

2010-05-06 Thread Michael Bayer
On May 5, 2010, at 11:46 PM, Kyle Schaffrick wrote: 1. While you can override existing operators that work on ColumnElements without doing much funny business, if you want to add *new* operations to it, the abstractions leak fairly badly. This seems to be because operator definitions aren't

Re: [sqlalchemy] PostgreSQL hstore custom type?

2010-05-06 Thread Kyle Schaffrick
On Thu, 6 May 2010 10:39:28 -0400 Michael Bayer mike...@zzzcomputing.com wrote: On May 5, 2010, at 11:46 PM, Kyle Schaffrick wrote: 1. While you can override existing operators that work on ColumnElements without doing much funny business, if you want to add *new* operations to it, the

Re: [sqlalchemy] PostgreSQL hstore custom type?

2010-05-05 Thread David Gardner
I was just considering something similar. Were you able to get far with this? On 04/07/2010 03:10 PM, Kyle Schaffrick wrote: On Wed, 7 Apr 2010 10:15:14 -0400 Michael Bayermike...@zzzcomputing.com wrote: Kyle Schaffrick wrote: Greetings, I'm looking into using PostgreSQL's

Re: [sqlalchemy] PostgreSQL hstore custom type?

2010-05-05 Thread Kyle Schaffrick
On Wed, 5 May 2010 15:01:08 -0700 David Gardner dgard...@creatureshop.com wrote: I was just considering something similar. Were you able to get far with this? Yes, actually I've got a pretty good start on it. The only obvious thing missing right now is a Comparator implementation so that the

Re: [sqlalchemy] PostgreSQL hstore custom type?

2010-04-07 Thread Michael Bayer
Kyle Schaffrick wrote: Greetings, I'm looking into using PostgreSQL's hstore type in a SQLAlchemy project, and before I possibly reinvent the wheel I was wondering if anyone has/knows of an implementation of an hstore custom type for SQLA? I'm basically just interested in simply mapping a

Re: [sqlalchemy] PostgreSQL hstore custom type?

2010-04-07 Thread Kyle Schaffrick
On Wed, 7 Apr 2010 10:15:14 -0400 Michael Bayer mike...@zzzcomputing.com wrote: Kyle Schaffrick wrote: Greetings, I'm looking into using PostgreSQL's hstore type in a SQLAlchemy project, and before I possibly reinvent the wheel I was wondering if anyone has/knows of an implementation

[sqlalchemy] PostgreSQL hstore custom type?

2010-04-06 Thread Kyle Schaffrick
Greetings, I'm looking into using PostgreSQL's hstore type in a SQLAlchemy project, and before I possibly reinvent the wheel I was wondering if anyone has/knows of an implementation of an hstore custom type for SQLA? I'm basically just interested in simply mapping a stand-alone attribute