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

[Bill Gunshannon]

In article <mdpu2e$tvs$1 at news.albasani.net>,
	Jan-Erik Soderholm <jan-erik.soderholm at telia.com> writes:
> 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!?
 
So, I take it what people are saying is that there really is no practical
use for or real interest in SQLite on VMS.  That being the case, I can
scratch that of my todo list.

bill 
 
 

-- 
Bill Gunshannon          |  de-moc-ra-cy (di mok' ra see) n.  Three wolves
billg999 at cs.scranton.edu |  and a sheep voting on what's for dinner.
University of Scranton   |
Scranton, Pennsylvania   |         #include <std.disclaimer.h>