Any database for x86 openVMS?
-
Topic author - Contributor
- Posts: 21
- Joined: Fri Mar 31, 2023 6:02 pm
- Reputation: 0
- Location: Erlangen/Germany
- Status: Offline
Any database for x86 openVMS?
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.
Thank you.
-
- Master
- Posts: 475
- Joined: Fri Apr 17, 2020 7:31 pm
- Reputation: 0
- Location: Rhode Island, USA
- Status: Offline
- Contact:
Re: Any database for x86 openVMS?
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.
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.
-
- Valued Contributor
- Posts: 96
- Joined: Thu Jun 06, 2019 6:57 am
- Reputation: 1
- Location: Brindisi (Italy)
- Status: Offline
- Contact:
Re: Any database for x86 openVMS?
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.
-
- Master
- Posts: 475
- Joined: Fri Apr 17, 2020 7:31 pm
- Reputation: 0
- Location: Rhode Island, USA
- Status: Offline
- Contact:
Re: Any database for x86 openVMS?
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.
I think Kerry Main started posting about them back in 2018.
It will be interesting to see how it works when it shows up.
-
Topic author - Contributor
- Posts: 21
- Joined: Fri Mar 31, 2023 6:02 pm
- Reputation: 0
- Location: Erlangen/Germany
- Status: Offline
Re: Any database for x86 openVMS?
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.
-
- Master
- Posts: 475
- Joined: Fri Apr 17, 2020 7:31 pm
- Reputation: 0
- Location: Rhode Island, USA
- Status: Offline
- Contact:
Re: Any database for x86 openVMS?
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.