Any database for x86 openVMS?

[spoofy]

Has anyone successfully compiled MySQL or PostgreSQL or any other database server on OpenVMS 9.2 x86? If so, are there any instructions?
Thank you.

[arne_v]

I am not aware of anything yet.

Rdb is promised for VMS x86-64 but latest say 24Q1 I believe.

There are 2 ports of MySQL/MariaDB for VMS (VSI and Mark Berryman). I assume they will be build on VMS x86-64 relative soon, but I don't think they are ready yet.

SQLite is about the same. I assume that it will be build on VMS x86-64, but I have not heard about it being ready yet.

I have no idea about Mimer's plans to support VMS x86-64.

It is well known that VSI is looking into PostgreSQL for VMS, but no official release yet (not for x86-64 and not for Itanium).

The Java databases cannot run on VMS x86-64 because Java is not ready yet. Java is promised soon I believe.

I think that it is very likely that you will have many options in 12 months, but not right now.

[m_detommaso]

I also wanted to point out SharkSQL DBMS for OpenVMS; a very ambitious project whose production release should be released by the end of this year. SharkSQL is developed by Wolfgang Burger of WDB Tech company.

Below, I report some information that I recovered from an event held in Holland on 7th March 2023.

SharkSQL development Goal:

• SQL standard compliant distributed relational DBMS system
• Easy‐to‐use with all features one would expect from an enterprise level DBMS
• Enhanced security and data protection features
• Multi‐Platform support – OpenVMS, Windows, Linux (future)
• OpenVMS release full cluster support
• Optimistic concurrency control and Pessimistic concurrency control
• Performance, Performance & Performance …

SharkSQL GRID access:

- Remote databases can be accessed directly from the client or via an access server
- SharkSQL DB engine is a distributed DB engine
− No configuration effort; SQL CONNECT statement only
− No risk of piggy‐back security holes; credential provided by the client are used to login to the remote DBMS
− No statement limitation; a user can execute all DML and DDL statements on the remote DBMS for which he is privileged.
− SQL statements remain syntactically strictly following the language definitions of the SQL standard

Note: The Client has always a “local” view on all connected DBs regardless if the are locally attached or remote

SharkSQL Connectors/Interfaces:

• Embedded SQL (initial release: C only)
• CVM pre‐compiler − comparable to Oracle/RDB SQL Module Processor
• SSTR (Secure Service and Transaction Router)
• Full MySQL/MariaDB wire protocol support, any connector available for MySQL/MariaDB can be used to access SharkSQL:

- JDBC
- ODBC
- ADO.NET
- C++ driver
- PHP
- Perl
- Ruby
- Go
- Rust
- Native connectors (especially ODBC and JDBC) will be provided


SharkSQL Release plan:

− Field test release mid2023
− Production release end 2023

Support Versions:

• VSI OpenVMS V8.4‐2L1 and higher
• HPE OpenVMS V8.4 (can be backup‐ported customer on request)
• OpenVMS x86 VSI OpenVMS 9.2 and higher
• Windows 10/11 and Windows Server 2016/2019/2022

Development plan (2024 – 2025):

− Linux port
− Database “shadowing”/database replication
− Adding new SQL features

• GROUPING SETS, CUBE and ROLLUP
• Enhanced Window functions (currently only basic features have beenimplemented).
− RMS file mapping (OpenVMS only)
− Native Connectors (ODBC, JDBC etc.)
− MySQL/MariaDB server integration


SharkSQL will be distributed as shareware

• Everyone can use it for free
• Customers will be charged only for Support and for Professional Service (Consulting and Training)

/Maurizio

[arne_v]

SharkSQL has always sounded rather cool.

I think Kerry Main started posting about them back in 2018.

It will be interesting to see how it works when it shows up.

[arne_v]

I have no idea about Mimer's plans to support VMS x86-64.

Update about Mimer:

https://www.mimer.com/mimer-announces-s ... nvms-v9-2/

[spoofy]

I can confirm that SQL 11.0.8A OpenVMS (x86_64) [Beta Test] is installed and working, at least as far as the test environment is concerned. Thank you.

[arne_v]

Mark Berryman just posted in comp.os.vms that there are issues with the MariaDB VMS port and the new C++ compiler currently in field test on VMS x86-64, so it may take some time before MariaDB becomes available.

[koenig]

Mimer SQL (https://www.mimer.com) has released a production version of Mimer SQL, 11.0.8E, for x86 on October 23, after 18 months of beta test. Can be downloaded with free evaluation license from https://developer.mimer.com/products/downloads/