Subject | Re: [Firebird-Architect] RFC: Cross database queries |
---|---|
Author | Jim Starkey |
Post date | 2007-08-01T14:29:20Z |
Roman Rokytskyy wrote:
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.
>> Below is draft version of proposal of how we may implement cross databaseIf it is done properly, it should work with any database for which there
>> 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?
>
>
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.