[Info-vax] VSI working on alternatives to Oracle Classic database

Jan-Erik Söderholm jan-erik.soderholm at telia.com
Wed Jan 20 19:05:57 EST 2021


Den 2021-01-21 kl. 00:55, skrev Arne Vajhøj:
> On 1/20/2021 5:46 PM, Jan-Erik Söderholm wrote:
>> Den 2021-01-20 kl. 21:44, skrev Craig A. Berry:
>>> On 1/20/21 2:30 PM, Arne Vajhøj wrote:
>>>> On 1/20/2021 2:51 PM, Craig A. Berry wrote:
>>>>> On 1/20/21 11:11 AM, Dave Froble wrote:
>>>>>> What I found interesting is the SQL Relay software.  Without knowing 
>>>>>> much about it, it still seems to be a solution, for those willing to 
>>>>>> use third party software.
>>>>>
>>>>> It's a library that speaks its own network protocol to a remote proxy
>>>>> agent that in turn talks to the remote database.  It might not have been
>>>>> that hard to port the client.  For people already calling a C API or
>>>>> something built on one, it could be a solution that is not too painful.
>>>>> But for people using a SQL precompiler for one of the traditional
>>>>> languages, there's a lot of pain headed their way.
>>>>
>>>> So it would be:
>>>>
>>>>         app              VMS
>>>>   SQL Relay client
>>>>          |
>>>> (SQL Relay protocol)   -----
>>>>          |
>>>>   SQL Relay proxy       Linux
>>>>    Oracle client
>>>>          |
>>>>   (Oracle protocol)     -----
>>>>          |
>>>>      Oracle DB          Linux
>>>>
>>>> ?
>>>
>>> That is my understanding.  Read all about it here:
>>>
>>> <http://sqlrelay.sourceforge.net>
>>
>> Very much like the "Rdb Transparent Gateway to ODBC data" that is
>> (was) part of the "Database Integration" (DBI) kit, that is still
>> available unsupported from Oracle for Alpha.
>>
>> That gateway (that had a standard Rdb SQL interface so it could
>> be called from any VMS language using the Rdb SQL precompiler, the
>> application did not now it was not accessing a real Rdb database)
>> connected to a Windows box where you can access any database (or
>> "data source") that had a ODBC driver.
> 
> The concept is pretty well-known.
> 
> Just in the J world I know of:
> * type 3 JDBC drivers
> * Apache ShardingsSphere proxy
> * PHP JDBC Bridge
> 
> But it will be a new client API. The applications will need
> to be changed.

Right.
The good thing with the DBI gateway was that it was *transparent*.
No new client API and no changes to applications.

Ah well, water under the bridges, I guess... :-)

> 
> That may be a small thing or a big thing depending on how
> well the database access is encapsulated.
> 
> Arne
> 
> 




More information about the Info-vax mailing list