Sujet : Mimer SQL
De : arne (at) *nospam* vajhoej.dk (Arne Vajhøj)
Groupes : comp.os.vmsDate : 21. Jun 2025, 02:29:45
Autres entêtes
Organisation : A noiseless patient Spider
Message-ID : <10351u9$boac$1@dont-email.me>
User-Agent : Mozilla Thunderbird
Mimer SQL is currently *the* database server available for VMS x86-64.
(we are still waiting for Oracle Rdb and MySQL/MariaDB)
Obviously they do document their client API's:
https://developer.mimer.com/features/database-apis/But in case someone are considering Mimer then here are my comments
to the API's.
Embedded SQL
support C, Fortran and Cobol
like any other embedded SQL implementation
works perfectly
Module
support C, Pascal, Fortran and Cobol
module definition practically compatible with Rdb module definition
works perfectly
note that the implementation is that the module definition is translated by MSQL to C with embedded SQL which is then translated by ESQL to C which is then compiler by C compiler (so C compiler is required no matter the application language!)
Mimer API (C API)
nice API much easier to use than libmysql, but my guess is that most C applications will use embedded SQL or module - they are just easier to use
JDBC (Java, Groovy, Kotlin, Scala, Jython etc.)
totally standard
can be used directly or with an ORM like JPA on top
ADO.NET (C#, VB.NET etc.)
totally standard
obviously not available on VMS
ODBC
totally standard
relevant in the Windows world
works with C/C++, Delphi, VB*, .NET etc.
mimerpy (Python)
installable via PIP
works both on VMS and non-VMS
standard DB API 2.0
works perfectly
PDO (PHP)
questionable support status (not available on VMS, only available for PHP 8.1 and 8.2 on Windows, require a build from source on Linux)
but if it is available then it is totally standard
Arne