[Info-vax] RDB Question

[Arne Vajhøj]

On 12/2/2018 7:20 PM, Dave Froble wrote:
> On 12/2/2018 5:45 PM, Richard Maher wrote:
>> What are the choices? ISAM, Ingres, MySQL, StartupSHark
>>
>> Apart from Legacy ISAM apps, If I wanted to use a cheap DB I'd go the
>> LAMP way.
> 
> First I'll say, I don't know of ALL of the choices.  But I'm sure there 
> are more than you've listed.

If one is willing to pick more "exotic" databases, then there
are many other.

> If I were designing an application today, I'd most likely use a 
> relational database product.  ISAM and such works, and can be fast for 
> updates, but the RDBMS beats the s**t out of it for retrival.  Of 
> course, it would depend on the application.

The tooling is just that much better for a RDBMS.

> As for VMS, either a DB has it's own locking, or, would use the VMS DLM. 
>   The DLM works in a cluster environment, which is a good feature.

Databases that support active/active need a DLM. Most come with
their own.

But the most common today is active/passive and all access via TCP/IP.

Arne