[Info-vax] What Will Drive More OpenVMS Adoption?

[Arne Vajhøj]

On 12/4/2021 5:46 PM, John Dallman wrote:
> In article <sogpfo$18sn$1 at gioia.aioe.org>,
> helbig at asclothestro.multivax.de (Phillip Helbig (undress to reply))
> wrote:
>> At the application level, using standard SQL, does anyone even have to
>> know what database is running?
> 
> Sadly, yes. SQL databases are not perfectly compatible:
> 
> <https://en.wikipedia.org/wiki/SQL#Interoperability_and_standardization>

If applications are written with the intention to be database
independent and effort is put in to stick to standard SQL-92,
then migrating is not a problem.

But if no such requirements has been defined because "we will never
change database", then ...

> The big database product my employer produces has a non-trivial
> abstraction layer for SQL databases. It supports Oracle and MS SQL Server,
> and has supported DB/2 in the past. The abstraction layer needs regular
> maintenance to cope with changes in databases.

That sounds like a pretty crappy abstraction layer.

Common ORM frameworks like Hibernate, EclipseLink, OpenJPA, Entity
Framework, NHibernate etc. got support for almost everything
either from the framework itself or supplied by the database
vendor.

Arne