[Info-vax] a cool database... as replacement for RMS index-sequential files:: Was: VSI working on alternatives to Oracle Classic database:

[Arne Vajhøj]

On 1/20/2021 10:13 AM, gérard Calliet wrote:
> Le 20/01/2021 à 15:12, Arne Vajhøj a écrit :
>> SQLite is a cool database, but I see it more as
>> replacement for RMS index-sequential files.
> Yeah?
> 
> I understand you think replacing some RMS index-sequential files by
> relational database is something not totally impossible.

Correct.

> It is a very unusual opinion. I'd like to hear more from you about that,
> examples if you have some, etc,...

I doubt it is that unusual.

SQLite simply has some advantages:
* better API for programmers
* much better tools for management
* fewer restrictions
* more portable
* skills more available

What not to like?

For a new VMS application then it is an easy choice.

For an existing VMS application then converting is most likely a good
thing in the long perspective, but since it means changes, then
it needs some analysis on when to do it. If the application
need major changes for other reasons, then it could be a good time
to convert.

Arne