Any database for x86 openVMS?

OpenVMS for x86 running Oracle, RDB, DBMS, ODBMS, Oracle, Ingress, Progress, Mimer, or open source databases. Various DB clients and ODBC drivers as well.
Post Reply

Topic author
spoofy
Contributor
Posts: 21
Joined: Fri Mar 31, 2023 6:02 pm
Reputation: 0
Location: Erlangen/Germany
Status: Offline

Any database for x86 openVMS?

Post by spoofy » Tue Apr 18, 2023 12:40 pm

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.

User avatar

arne_v
Master
Posts: 435
Joined: Fri Apr 17, 2020 7:31 pm
Reputation: 0
Location: Rhode Island, USA
Status: Offline
Contact:

Re: Any database for x86 openVMS?

Post by arne_v » Tue Apr 18, 2023 3:38 pm

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.
Arne
arne@vajhoej.dk
VMS user since 1986

User avatar

m_detommaso
Valued Contributor
Posts: 87
Joined: Thu Jun 06, 2019 6:57 am
Reputation: 1
Location: Brindisi (Italy)
Status: Offline
Contact:

Re: Any database for x86 openVMS?

Post by m_detommaso » Wed Apr 19, 2023 9:33 am


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
Last edited by m_detommaso on Wed Apr 19, 2023 9:34 am, edited 1 time in total.

User avatar

arne_v
Master
Posts: 435
Joined: Fri Apr 17, 2020 7:31 pm
Reputation: 0
Location: Rhode Island, USA
Status: Offline
Contact:

Re: Any database for x86 openVMS?

Post by arne_v » Wed Apr 19, 2023 1:58 pm

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
arne@vajhoej.dk
VMS user since 1986

User avatar

arne_v
Master
Posts: 435
Joined: Fri Apr 17, 2020 7:31 pm
Reputation: 0
Location: Rhode Island, USA
Status: Offline
Contact:

Re: Any database for x86 openVMS?

Post by arne_v » Thu Apr 20, 2023 7:17 pm

arne_v wrote:
Tue Apr 18, 2023 3:38 pm
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/
Arne
arne@vajhoej.dk
VMS user since 1986


Topic author
spoofy
Contributor
Posts: 21
Joined: Fri Mar 31, 2023 6:02 pm
Reputation: 0
Location: Erlangen/Germany
Status: Offline

Re: Any database for x86 openVMS?

Post by spoofy » Fri Apr 21, 2023 4:42 am

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.

User avatar

arne_v
Master
Posts: 435
Joined: Fri Apr 17, 2020 7:31 pm
Reputation: 0
Location: Rhode Island, USA
Status: Offline
Contact:

Re: Any database for x86 openVMS?

Post by arne_v » Tue Apr 25, 2023 1:07 pm

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.
Arne
arne@vajhoej.dk
VMS user since 1986

Post Reply