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

[Stephen Hoffman]

On 2015-03-12 02:25:59 +0000, Craig A. Berry said:

> On 3/11/15 10:02 AM, Stephen Hoffman wrote:
>> 
>> I've been using that SQLite port for a prototype project, and it works 
>> as expected.  Haven't started tossing any volume of queries at it, nor 
>> looked at updating it.  But it works.
>> 
> Have you tested multi-user access to the database yet?
> 

Not yet.  The prototype application I'm working on has only limited 
need for shared access, so it wouldn't be the best test.  It's 
application-level preferences and settings, a moderate-sized data store 
with multiple indexes, and is not performing high-volume or 
multi-threaded I/O.

Yes, this is an application which is entirely possible within RMS, with 
multiple files, some parsing, and rather more effort than the SQLite 
code has required so far — though given the choice, less work and more 
portable code is preferable to rummaging RMS indexed files.  Like many 
other smaller projects, Oracle Rdb or Oracle Classic would be technical 
and financial overkill, and it's presently not available in the target 
environment, should the prototype work out.

> For some reason I have an impression that SQLite works ok in 
> single-user mode on VMS but cannot do shared access until SSIO is 
> complete and working and the (as-yet-undocumented) DECC$SSIO feature 
> logical is defined.

The only SSIO-related discussion I can find in the context of SQLite is 
one where you asked about SSIO.

The only issue I've seen raised within the context of SQLite involved 
an unspecified C-related or locking-related patch, though that quest 
has involved a web page at Phillip Vouter's site 
<http://vouters.dyndns.org/tima/OpenVMS-SQLite-A_possible-reason_why_SQLite_does_not_work_under_OpenVMS.html>, 
and that page is presently offline, and that page is not archived at 
<http://archive.org>, and am yet unable to coax Google into offering a 
cached version over there.   That web page may have been removed.  
Whether that unspecified patch is necessary here, or is already in 
V8.4, or will be in "Bolton", I don't know.

PostgreSQL does reportedly have a requirement for shared stream I/O 
(SSIO) support.  Might that be what you are recalling?


-- 
Pure Personal Opinion | HoffmanLabs LLC