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

[Bill Gunshannon]

In article <mdsb1g$5ed$1 at dont-email.me>,
	Stephen Hoffman <seaohveh at hoffmanlabs.invalid> writes:
> On 2015-03-12 13:06:01 +0000, Bill Gunshannon said:
> 
>> 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.
> 
> Among those that have Oracle licenses, interest in anything other than 
> Oracle will probably be pretty low.  Among others, interest is unclear, 
> and largely up to individual sites and to VSI, if VSI decides to 
> integrate and to start to make use of a database.
> 
> A precompiler would be nice, but it's going to be a fair amount of 
> parsing work to get it to the level of the Rdb precompiler parser, and 
> to get it integrated into the language more completely than what Rdb 
> does (or did — the precompiler may well have been updated since my last 
> use), that's probably going to involve a integrating a language-parsing 
> library such as LLVM, and that's not going to be an option with VMS for 
> a few years.

Actually, there is an SQL Syntax Checker and an SQL Precompiler included
in the book lex&yacc from O'Reilly and a recent query to one of the authors
expressed that he was no problem with using it as the basis for an Open
Source finished product as long as credit was given.  SQLite seems a good
target because it really is a rather small subset of SQL.  

> 
> More than the precompilers, it's the ad hoc query tools that I miss — 
> InstantSQL is about the only option on OpenVMS, and that disappeared an 
> aeon or two ago AFAIK.  Those tools could well generate the necessary 
> language-specific code, too.   But that's only if you're itching to do 
> some SQL work somewhat above the level of a language processor / 
> precompiler.  On OS X, the equivalent available tools include Sequel 
> Pro <http://www.sequelpro.com> and PSequel <http://www.psequel.com>
 
Well, I will probably take a shot at it anyway as I only do this for fun
and really wouldn't care if no one used it.  Sadly, everything is not
moved tot he new house yet and when I went by the old house yesterday I
failed to grab the Alpha or any of the VAXStations.  So I guess i won't
be starting this weekend.  At least not on the VMS version.  :-)

Hmmm....  Hey Dave, what about an SQLite Pre-compiler for VMS BASIC? :-)

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>