Re: VMS x86-64 database server

On 7/6/2025 6:39 PM, Craig A. Berry wrote:

On 7/6/25 2:45 PM, Arne Vajhøj wrote:

So what is happening here?
>
PostgreSQL on VMS x86-64????
>
No. Sorry.
>
I am using a little trick. H2 can emulate both PostgreSQL
SQL dialect and PostgreSQL network protocol.

 As well as others, apparently.

It can emulate a lot of different SQL dialects.
But only PostgreSQL network protocol I believe. Which
is important, because that is what allows usage
of a PostgreSQL client library.

                               Did you have existing code, tooling, or
experience that made the emulated route more attractive than just using
H2's own ODBC/JDBC interfaces?

The trick is not interesting for Java and other JVM languages as
the JDBC driver is available.
It is interesting for languages where there are no H2 driver
available but a PostgreSQL driver available.
On VMS that means C out of the box via VSI provided libpq.
But it also means that other native languages (Pascal, Basic,
Fortran etc.) just need a wrapper to use libpq to talk to
H2.
And that PHP pgsql & pdo_pgsql and Python psychopg2
should be just a build problem.
Arne