[Info-vax] Other than Oracle, What MySQL/DBMS options are there for OpenVms?

[Arne Vajhøj]

On 3/25/2019 9:02 PM, Dave Froble wrote:
> On 3/25/2019 7:31 PM, Arne Vajhøj wrote:
>> On 3/25/2019 4:27 PM, Jan-Erik Söderholm wrote:
>>> Den 2019-03-25 kl. 20:37, skrev Denys Beauchemin:
>>>> Jon was exactly correct, I apologize for not being clearer in my
>>>> original answer.  Yes, the Postgres client works very well on OpenVMS
>>>> and allows the application on OpenVMS to have full communication with a
>>>> Postgres server on any platform that supports it.
>>>>
>>>> We are helping customers transform their OpenVMS code from Rdb 
>>>> access to
>>>> Postgres access and that way the application can remain on OpenVMS for
>>>> the foreseeable future.
>>>
>>> Why would staying with Rdb be an issue for staying with VMS?
>>> Apart from the costs, of course.
>>
>> Cost if often a very important factor in business
>> decisions.
>>
>> Besides that and with the caveat of not knowing much about
>> neither RDB nor PostgreSQL, then I would expect RDB to be
>> lacking some features among what has become common in
>> databases within the last 20 years.
>>
>> If you say that >90% of users do not need those
>> features, then I will say that you are probably right.
> 
> That's some rather rash speculation, unless you have some justification. 
>   Just because HP ignored VMS doesn't mean Oracle ignored RDB.

It is my clear impression that Oracle has provided fine support
for RDB, but I do not think they have evolved the product that much.

Version number wise RDB has taken 23 years to go from 7.0 to 7.3.

But we can check. Can someone with extensive RDB knowledge
tell what RDB support from the list below:
* CTE in SQL
* full text search
* N data types
* BLOB and CLOB data types (with 1 GB or more max size)
* XML and JSON data types
* geospatial data types
* stored procedures in other languages than SQL
* encrypted connections
?

> However, if all data used to be on VMS, then there would be the need for 
> another non-VMS server, and the expertise to use it.

Most VMS users has experience with other OS these days.

Linux, Windows, maybe some classic Unix.

Arne