[Info-vax] VMS databases

[Neil Rieck]

On Friday, November 17, 2023 at 8:10:25 PM UTC-5, Arne Vajhøj wrote:
> I just did another little article. 
> 
> https://www.vajhoej.dk/arne/articles/vmsdbx.html 
> 
> providing some examples for the databases available on VMS (Rdb, MySQL, 
> SQLite, Mimer, Derby, H2, HSQLDB) in various programming languages 
> (Cobol, C, Pascal, Java, Jython, Python, PHP). 
> 
> Nothing surprising and a lot of overlap with previous 
> articles, but a different perspective. 
> 
> Arne

This is a very impressive publication. On behalf of the OpenVMS community I say "thanks!"

Two additional points. 

1) I've done a bit of hacking with SQLite (on both OpenVMS + Linux ) and can inform that it should only be used in single user applications. When any process issues an "update table" command, all other processes are locked out.

2) Back in 2016 I received a copy of MariaDB-5.5 for OpenVMS Itanium from Mark Berryman. Since 90% of our VMS stuff is written in BASIC, I spent more than a few days trying to glue Mark's client code to my BASIC programs (we are in the process of moving our data from RMS to MariaDB). Linking the object files was fairly easy using Mark's instructions. Trying to pass string arrays from C to BASIC was a little more difficult. My eventual solution involved created string arrays in a BASIC declared COMMON then had C employ str$get1_dx() to copy the data back. I would be interested to learn if you had a better method.

https://neilrieck.net/demo_vms_html/mysql_api_demo14_c.html (crude c demo)
https://neilrieck.net/demo_vms_html/mysql_demo14_bas.html (crude BASIC demo)

Neil Rieck
Waterloo, Ontario, Canada.
https://neilrieck.net