We don't currently have a ticket to build a version in the core, though I'm not sure if someone out there is working on one.
Assuming psycopg2 supports this type (which is likely), basic storage could be achieved with a simple UserDefinedType subclass (1). As mentioned in the thread, some work with operators could make it nicer at the SQL construction level. Right now whatever SQL HSTORE requires should in theory be achievable with a combination of "op()" (2) and/or custom clause elements (3). 1: http://www.sqlalchemy.org/docs/core/types.html?highlight=userdefinedtype#sqlalchemy.types.UserDefinedType 2: http://www.sqlalchemy.org/docs/core/expression_api.html?highlight=op#sqlalchemy.sql.expression.Operators.op 3: http://www.sqlalchemy.org/docs/core/compiler.html?highlight=compiles On Jul 26, 2011, at 6:46 AM, Adam Tauno Williams wrote: > An Internet search found reference to HSTORE [1] support being under > some development in mid 2010 [2]. But I can find no more recent > mentions of support for HSTORE. Anyone know the status of HSTORE > support in SQLalchemy? > > [1] <http://www.postgresql.org/docs/current/static/hstore.html> > [2] > <http://www.mail-archive.com/[email protected]/msg19441.html> > > -- > Adam Tauno Williams <[email protected]> LPIC-1, Novell CLA > <http://www.whitemiceconsulting.com> > OpenGroupware, Cyrus IMAPd, Postfix, OpenLDAP, Samba > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
