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

[Dave Froble]

On 3/22/2019 1:18 PM, Bill Gunshannon wrote:
> On 3/21/19 11:04 PM, Stephen Hoffman wrote:
>>
>>
>> Irrespective of what I've seen listed in Wikipedia, PostgreSQL is
>> *not* available for OpenVMS,
> Just out of curiosity, is there a particular reason for this?  Other
> than just no one being interested enough to work on a port.
>
> bill

PostgreSQL uses a C capability called SSIO and it's basically, from what 
I understand, a form of numeric range locking.  Others understand it 
more than I do.

However, I'bve been claiming for a while that a simple (I'd think) new 
capability in the DLM would allow the capability to be made available.

Adding a "type of lock" to the DLM database tables would then allow 
additional code to be invoked, based upon the "type of lock", and a type 
for numeric range locking could have passed a set of numbers, perhaps in 
the domain name field, perhaps another, that now exists, or is added. 
The special code could then work with the numeric range, looking for 
overlaps in the DLM database.

It makes one wonder why multiple types of locks were not
in the initial implementation, but, we're talking 1984.

An interesting question might be, what third type of lock might be 
useful?  Or fourth?

I sure could have used the capability back in 1984.  Instead, when 
locking up to 127 contiguous blocks, it takes 127 locks.

:-(

-- 
David Froble                       Tel: 724-529-0450
Dave Froble Enterprises, Inc.      E-Mail: davef at tsoft-inc.com
DFE Ultralights, Inc.
170 Grimplin Road
Vanderbilt, PA  15486