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

Arne Vajhøj arne at vajhoej.dk
Wed Jan 20 18:55:04 EST 2021


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.

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