From: arne@vajhoej.dk   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)