[Info-vax] Best tools for remote MySQL access

[Craig A. Berry]

On 3/25/21 10:06 AM, Rich Jordan wrote:
> We have a customer currently running their website on a wintel
> server/IIS with MS SQL Server backing it.  Their onsite VMS servers
> communicate with the webserver via the FreeTDS package via DEC BASIC,
> the only licensed compiler they have.
> 
> They want to move to a hosted solution for the website, and are
> currently evaluating Wordpress.  The backing database there is MySQL.
> I did a little poking and see some DEC C-interface options that could
> be called from DEC BASIC, and I'm pretty sure we could use STunnel to
> provide the secure connection to the hosting site.  We might also
> consider putting Python on the VMS box to do the MySQL interfacing
> since it supports it pretty well.
> 
> If anyone has done similar are there specific tools or methods you
> would recommend for making this connection?
> 
> We have suggested, simply for ease in the conversion, that they
> consider a hosting service on windows with SQL server.
> 

It looks like VSI's MariaDB package includes the client library:

<https://vmssoftware.com/docs/libmariadb-release-notes.pdf>

and it claims to include a "language-agnostic API."