Subject Re: [Firebird-Architect] RFC: Cross database queries
Author Jim Starkey
Roman Rokytskyy wrote:
>> Below is draft version of proposal of how we may implement cross database
>> queries. It is not a truth at a last instance, it is incomplete and may contain
>> bugs (don't register them at tracker, please ;))
>>
>
> One question that needs clarification, I think, - are we talking about
> queries to other Firebird databases or we are talking about the queries
> also to other databases as well?
>
>

If it is done properly, it should work with any database for which there
is a gateway provider. The code that implements foreign database access
simply loops back to the dispatch module with whatever was given as a
dispatch string.

In keeping with this, might I suggest that the "provider" clause is
neither necessary nor desirable? All information necessary to connect
should be bundled into the connection string. That said, however, there
may be other connection attributes necessary beyond account and
password, so perhaps generalizing the syntax to handle a more open ended
approach might be a good idea.