[odb-users] Adding support for a new sql type

[Boris Kolpackov]

Hi Alexandre,

Boris Kolpackov <boris at codesynthesis.com> writes:

> Now, if the new type is "interfaced with" using one of the existing SQL
> types (which, as I understand, is the case with GEOMETRY), then this
> could be easier. Then we could probably "map" the new type to the
> existing type. We would probably also need to specify to/from
> conversion expressions (ST_GeomFromText/ST_asText in case of GEOMETRY?)
> that will need to be applied in the INSERT, UPDATE, and SELECT statements
> generated by the ODB compiler.

In case you are still interested in GEOMETRY support in ODB, I just
finished implementing this feature for 2.1.0. As it turns out it can
be used to support all kinds of "additional" database types besides
GEOMETRY (things like user-defined types, arrays, XML, etc.).

Let me know if you would like to give this feature a try before the
release.

Boris