[Info-vax] SQLite port for OpenVMS (Re: Is there currently a functioning link for hobbyist licenses?)

[Jan-Erik Soderholm]

Stephen Hoffman skrev den 2015-03-11 16:38:
> On 2015-03-11 13:56:03 +0000, Jan-Erik Soderholm said:
>
>> OK, I have read up a bit on SQLite. I have a hard time seeing why VMS
>> would be a prime candidate for SQLite.
>
> Vastly more flexible than RMS, and with much easier licensing and lower
> costs than using Oracle Rdb or Oracle Classic, for starters.
>
> That's before discussing and dealing with source code that already uses
> SQLite, of course.
>
>> Might work OK for Firefox to keep track of the setup things in the local
>> browser, but that is a single user environment. OK, they say that SQLite
>> is the most widely deployed database product in the world. Right, hard to
>> beat 500 Miljon Firefox "users". But how many of them has actively
>> selected SQLite? :-)
>
> Far more than chose Oracle Rdb on an AlphaServer DS20 running OpenVMS
> Alpha...

I do not think that even one single Firefox user has actively
selected SQLite! It just came embedded into the product...

> most likely, and there are probably things in your environment that
> might work well with SQLite...

No, it would not. There are so much missing from SQLlite that you
normaly expect. Backup handling. After image logging with roll
forward after a restore. If you crash you have nothing else
then the last backup. No traces what so ever from your updates
done since last backup... "Work well"? :-)

OK, that is not worse then using RMS without RMS Journaling,
but it is not something you expect from a database.

SQLite is of course not a usable replacement for something
like Rdb (or anything similar database product).

> SQLite is one of the stock databases on a number of platforms, and it
> embeds easily directly into applications.

Exactly. SQLite is primarily an "embedded database", either in
applications as such (Firefox) or into equipment such as tablets
and phones.

>
> It's exceedingly popular in the embedded space,and it's quite popular on
> Linux, Android / ASOS, OS X, iOS and a number of other places...

Right. And that is also where VMS is used, is it?

> If you have
> a smart phone, you've almost certainly used apps that use SQLite.

I just could not care less, as long as my phone works.
Exactly what has that to do with databases for VMS!?