Re: VMS x86-64 database server

On 7/6/2025 3:45 PM, Arne Vajhøj wrote:

As we all know then the available options are currently very limited.
 But I just found a little trick to get one more.
 :-)
 $ write sys$output f$getsyi("VERSION")
V9.2-3
 $ type TestPG.java

...

$ javac TestPG.java
$ java -cp .:/javalib/postgresql-42_5_1.jar TestPG
1 A
2 BB
3 CCC
 $ type test.c

...

$ cc /include=libpq$root:[include] /name=as_is test
$ link test + libpq$root:[lib]libpq/libr + libpq$root:[lib]libgpgtypes/ libr + ssl111$lib:ssl111$libssl/libr + ssl111$lib:ssl111$libcrypto/libr
$ run test
1 A
2 BB
3 CCC
 C:\IDEProjects\EclipsePHP\Test>type TestPDO.php

...

C:\IDEProjects\EclipsePHP\Test>php TestPDO.php
1 A
2 BB
3 CCC
 I cannot use PHP on VMS yet as I don't have a PHP with pgsql and
pdo_pgsql. But given that libpq is ported, then those can probably
be build.

About the same with Python. Trying to install psycopg2 with
pip fails, but given that VSI provide libpq, then I assume
that someone with Python+C+VMS skills could build it.
It is worse with embedded C.
VSI libpq port does include ecpg and it works and the
result can connect to H2 just fine.
But there are some incompatibilities between H2 in
PostgreSQL mode and real PostgreSQL.
And one of them is that H2 in PostgreSQL mode
does not support server side cursors.
And embedded SQL without "FETCH cursorname INTO ..."
is like a hotdog without a hotdog sausage!
Arne