[storm] Handling non-standard database types

[James Henstridge]

On Wed, Sep 2, 2009 at 1:35 AM, Dan Halbert<halbert at halwitz.org> wrote:
> I am interested in using Storm with PostgreSQL, including some atypical data
> types. Specifically, my PostgreSQL tables have POINT, BOX, and POINT[]
> (array of POINT) column types, and a few enumerated types.
>
> I understand how to use Enum() for the enumerated types, if I wanted to
> remap the values. But how can I handle the other types? I have already
> successfully written psycopg2 adapters for these types.
>
> I've done a cursory look, and it appears I need to add Point, PointVariable,
> etc. to properties.py and variables.py. Or is there some other way to do
> this neatly? Would POINT[] just get converted into a List()?

Defining Point and PointVariable types would be the way to handle
this.  They don't need to be part of Storm proper, but can live in
your application if you want.

James.