Re: [INTERFACES] Type mappings

>
> tomas(at)aura(dot)de wrote:
[...]
> Types don't change too often. Not often enough to hurt the
> UI's anyway, which is what JDBC is for. On the other hand,
> speed gain from caching type information is significant.
>
Ummm... I wasn't implying not to cache the types -- I think
caching is a must. But we could (for example) invalidate the
cache whenever anything happens to the pg_types table (that
would imply setting up a notifier (did I get the PostggreSQL
parlance right?)

> > It would be interesting to write up a type mapper which could be
> > of some more general utility (no idea whether this would be
> > feasible at all). I'd be willing to give it a try.
>
> It is a useful thing. E.g. my project needs conversion between
> SDDF, SQL, (restricted form of) Prolog, and Jess (don't ask
> why--it's a long story). I would definitely appreciate a
> generic type mapper. It is feasible too. My chicken scratch
> has worked so far. :)
>
The question is... what do we use as the target data types? I
could just go for the Guile data types -- but then we have
Just Another Type Mapper, Not Useful To Anyone (TM). Maybe
with a bit more of thought (say you can register conversion
functions with it, depending on the PostgreSQL type name (but
it might make sense to base our decisions on other attributes
of the table, like the input/output functions)) we could
get something more useful.

> JDBC source has the queries you need. PostgreSQL manual
> decribes the types. It's just a matter of sitting down
> and writing a pretty wrapper/converter.
>
Thanks, I'm already having a look at it. It's very readable.

regards
-- tomas