Subject Re: [Firebird-Architect] RFC: Cross database queries
Author Roman Rokytskyy
> Why not? If we need to talk to external datasources, this is the best place
> for them.

I'd like to hear Dmitry's comments on this - he had some plans for
provider architecture, if I'm not mistaken...

>>> This is the only positive i see in extending CREATE TABLE :)
>> Well... if you have a better idea to handle long tables names from other
>> database engines in XSQLVAR without changing the XSQLDA version or API -
>> I'm all ears :)
>
> Let's do not forget that this feature is not for 2.1 and even not for 3.0,
> which should me merge version. I suppose we may prepare to introduce new
> versions of SQLDA, SPB, may be even DPB/TPB in some version in the future -
> anyway sooner or later we need long identifiers.

Yup... only that external datasources is one of the very demanded
features, but most people can live with 31-byte long identifiers. I'm
inclined to put such dependency on our roadmap at the moment.

Anyway, I'd like to hear list of problems with ASA's approach to
external tables, since it is an alternative approach to Vlad's and does
not require XSQLDA version change and therefore can be implemented with
current API.

Roman