On 11/18/2023 9:22 AM, Arne Vajhøj wrote:
On 11/17/2023 8:10 PM, 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.
Niel Rieck replied (for some reason the post did not propagate
to eternal-september, so this is a manual copy from Google Groups):
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.
VMS Basic is as it is and the libmysql API is what it is and
any solution is constrained by that.
I do not have any magic solution for the problem. I would
probably have made the API differently (but differently does
not necessarily mean better).
I could not resist trying.
This is first attempt. But I think it is a relative clean API.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 418 |
Nodes: | 16 (3 / 13) |
Uptime: | 50:07:08 |
Calls: | 8,814 |
Calls today: | 10 |
Files: | 13,307 |
Messages: | 5,973,240 |